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