Paste Link and Concatenation

[don]

Hi,

I have a spreadsheet that I am making into a template. It uses paste
links to three other worksheets. Each of the finished templates could be
used in around 20 different folders within our network with the three
linked worksheets being different for each folder.

We use a department ID no. as a unique key and I have created a lookup
table that can return the link pathname that it should be pointing to.

My question and my problem is can I then use Concatenation to add the
sheet and cell address to the file pathname to create my paste link address.

Hope you may be able to help.

Regards

Don

 

[Pete_UK]

The usual way of doing this is with the INDIRECT( ) function. However,
this will only work if the file(s) that it refers to is/are open. You
can find more details on INDIRECT( ) in the Excel Help files.

Hope this helps.

Pete

 

[don]

The usual way of doing this is with the INDIRECT( ) function. However,
this will only work if the file(s) that it refers to is/are open. You
can find more details on INDIRECT( ) in the Excel Help files.

Hope this helps.

Pete

Pete thank you for your reply, do you know if VBA can help to overcome
this restriction?