change a function in a workbook without changing every cell

[sir lancelot]

I am linking several workbooks to one workbook. The workbooks name change
every month. How can I create a formula that I can change without having to
change every cell in the new workbook?

 

[Naomi]

You can use the 'indirect' function to make a text reference into a life
link. Look at XL help for more

 

[Ron de Bruin]

Hi

Indirect is not working with closed workbooks
You can do a Edit>Replace or if your Excel version have this use
Edit>Links

Or if there are not so many cells you must link to use a macro
http://www.rondebruin.nl/summary2.htm

 

[sir lancelot]

This appears to work. Thanks for the help.

Hi

Indirect is not working with closed workbooks
You can do a Edit>Replace or if your Excel version have this use
Edit>Links

Or if there are not so many cells you must link to use a macro
http://www.rondebruin.nl/summary2.htm