Two Linked Files But I Change Files Names Each Job

Hi,

I basically have two files lets say file A and file B. File B has more than 20 cells that are linked to file A. The problem am afraid off is that each job I name files differently based on the custormer name or what ever. I want to use the same files content (as a template) for each job with the links between them as is but I belive file B (which will be D) will not recognize cells in file C because it is linked to file A.

I am trying to get your help if there is a way to have file B or D update links and have them change file name (not cell locations) automatically. As you know a link between two seperate files will include the file name between brackets followed by worksheet name and cell number as shown:

='[A.xls]sheet1'!B10

To make it even simpler, if I input file A's name in a cell in file B, can I use the content in that cell to update the linked cells path i.e. change the previous file name with the name in that cell and keep sheet name and cell number the same?? Is this possible???

I really appreciate your help and suggestions. If someone has a butter idea he is more than welcome

thanks

Haab

Yes you can use content of cell like this:

=INDIRECT("'["&X1&".xls]sheet1'!B10")

where X1 contains the file name to reference..

This only works with open referenced workbooks...

To work with closed workbooks you need to download a free add in called Morefunc and apply formula as

=INDIRECT.EXT("'["&X1&".xls]sheet1'!B10")