Custom Defined Cell Links

RhodsUK

New Member
Joined
Aug 14, 2007
Messages
4
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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Welcome to the board! :)

Try this:
Code:
=INDIRECT("["&B1&"]WORKSHEET1!A1")
 
Upvote 0
Works perfectly on my simple example!

Thank you for introducing me to what seems like a very useful formula.
 
Upvote 0
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. :)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top