Make an onchange event for the source cell that updates the formula in the target cell. That's a nice exercise in VBA (not the most easy thing to start with, I'm afraid).
Kees
I am tracking 50 to 100 areas at any one time in an equal number of spreadsheets. All the spreadsheets have identical layouts. I would like to link these files to a master roll-up file. I need two elements to change in my links based on two identifiers, area number and name. In Lotus, yes I'm that old, I could just designate a cell to each and each time I changed the information in the cell the formula would change. I'm sure that there is an Excel way to do this, I just don't have a clue. Here's the formula D:\Documents and Settings\mtontini\Desktop\PCDS Trackers\[PCDS Tracker TX141 Austin 2011.xls]Summary'!$C$5
The two variables that I want to have change based on a cell's input are TX141 and Austin.
Thanks for any help you can offer.
Thanks

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic