Linking to other spreadsheets - complex formula

[Guest]

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???

 

[Pete_UK]

Can't you highlight the sheet and use CTRL-H (Find and Replace) to:

Find What: Jan.xls
Replace With: Feb.xls

then click Replace All? You seem to be suggesting that you currently
change all the references manually.

Hope this helps.

Pete

 

[Guest]

The problem is that the page has multiple links to about fifteen different
spreadsheets, so I would have to use the FIND feature repeatedly for each
file. This may end up being my only option, but having it link to a single
page where all the file names are listed and making the change there would
ensure I capture all the links versus checking each highlighted cell
(highlighted in blue to help me remember which have links) and then
determining what links to update.

Can't you highlight the sheet and use CTRL-H (Find and Replace) to:

Find What: Jan.xls
Replace With: Feb.xls

then click Replace All? You seem to be suggesting that you currently
change all the references manually.

Hope this helps.

Pete

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???