| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
change a function in a workbook without changing every cell
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? |
|
#2
|
|||
|
|||
|
You can use the 'indirect' function to make a text reference into a life
link. Look at XL help for more "sir lancelot" wrote: 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? |
|
#3
|
|||
|
|||
|
Hi
Indirect is not working with closed workbooks You can do a EditReplace or if your Excel version have this use EditLinks Or if there are not so many cells you must link to use a macro http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Naomi" wrote in message ... You can use the 'indirect' function to make a text reference into a life link. Look at XL help for more "sir lancelot" wrote: 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? |
|
#4
|
|||
|
|||
|
This appears to work. Thanks for the help.
"Ron de Bruin" wrote: Hi Indirect is not working with closed workbooks You can do a EditReplace or if your Excel version have this use EditLinks Or if there are not so many cells you must link to use a macro http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Naomi" wrote in message ... You can use the 'indirect' function to make a text reference into a life link. Look at XL help for more "sir lancelot" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) | |||
| Excel should have a quick and simple "change case" function like . | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
Hybrid Mode
