| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files in Excel
I have to excel files, file A and file B. I am importing several data points
from file A to file B. For example cells in File B have the following values: 'C:\Excel Files\Monthly Data\File A.xls'!Transfer_Final_Amount_Total 'C:\Excel Files\Monthly Data\File A.xls'!Transfer_Total_Discrepency 'C:\Excel Files\Monthly Data\File A.xls'!Transfer_Final_Adjustment My issue is that if I change the location of File A or even the name of File A the I must individually remake all of these links to File B. Is there anyway to do put the location of File A as a reference in File B and thus just change one thing and all the other references automatically update? Thank you for any help Mark Other |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Excel Files | Excel Worksheet Functions | |||
| Linking files in excel | Excel Discussion (Misc queries) | |||
| Linking Excel Files | Excel Discussion (Misc queries) | |||
| Linking two excel files | Excel Discussion (Misc queries) | |||
| linking picture files to excel | Excel Discussion (Misc queries) | |||
Threaded Mode
