Custom Defined Cell Links

[RhodsUK]

A simple question for a first post.

What I want is to be able to manipulate a cell link to a speperate workbook by way of changing a cells contents.

i.e.

='[DocumentName.xls]WORKSHEET1'!A1

Instead of DocumentName.xls as a permanent addition to the string, I want to be able to manipulat this by link with a cell in the workbook which the above formula is present.

i.e.

='[B1]WORKSHEET1'!A1

where B1 could equal DocumentName1.xls, DocumentName2.xls etc.

Thanks for your help,

Rhodri.

 

[Lewiy]

Welcome to the board!

Try this:

=INDIRECT("["&B1&"]WORKSHEET1!A1")

 

[RhodsUK]

Works perfectly on my simple example!

Thank you for introducing me to what seems like a very useful formula.

 

[Lewiy]

Useful, yes, but be careful not to use it too much as it is very labour intensive and will eventually slow down your worksheet calculation time if you have too many.