| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking to other spreadsheets - complex formula
Tough one...I have a "Socrecard" spreadsheet that is loaded with links to
other "data source" spreadsheets. Each month, I have to open each cell and change the pointer from, for example, ='G:\2006\[Jan.xls]CONSOLIDATED VIEW'!$CR$64 to ='G:\2006\[Feb.xls]CONSOLIDATED VIEW'!$CR$64. For now, I can use CNTL F and the find feature to search for Jan, then replace with Feb, but I would like to have one page of the excel SS with Jan, Feb, Mar, etc and have the cell point to it like this ='G:\2006\[POINT TO CELL HERE.xls]CONSOLIDATED VIEW'!$CR$64. Possible??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow multiple rows of worksheet tabs for complex spreadsheets | Excel Discussion (Misc queries) | |||
| complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
| complex linking data and files | Excel Discussion (Misc queries) | |||
| Simple way to breakdown complex spreadsheets | Excel Discussion (Misc queries) | |||
| How to stop #REF! on linked cells in complex spreadsheets | Excel Worksheet Functions | |||
Threaded Mode
