C
California Phil
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???
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???