Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External addressing
I have a large sheet that consolidates information from about five other
sheets. These other sheets constantly get name changes, as we indicate changes with a date change in the title. Is there a way that I can input current file names in five cells in the master sheet, then use these cells to direct external references. Changing all the formulas in a complex sheet is not easy, nor is it much fun. Any ideas will be welcome. Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
addressing in formulas | Excel Discussion (Misc queries) | |||
Cell addressing | Excel Worksheet Functions | |||
Relative addressing | Excel Worksheet Functions | |||
VBA Cell Addressing | Excel Discussion (Misc queries) | |||
Relative Addressing | Excel Discussion (Misc queries) |