Links to other workbooks

[Bru86]

I have a question concerning making links to other workbooks.

Is it possible to integrate a cell reference into the filename of the workbook you're linking to ?

This is my problem : I already have Workbook 1, Workbook 2, Workbook 3, ... In another Excel-workbook, I want to refer to "Workbook A5" ; it depends on the value of cell A5 (1,2,3,...) to which workbook (1,2,3, ...) the link is made.

Can this be implemented ?

Thanks a lot !

 

[Lewiy]

Try:

=INDIRECT("[Workbook "&A5&"]Sheet1!A1)

This will give you the value of A1 in Sheet1 of the workbook whose number appears in A5.

Hope that helps

 

[Bru86]

This formula works fine !

Thanks for the quick answer !

Bru86