Linking to information within a cell

C

charob

I am trying to link to the information within a cell instead of the cell
location. The reason that I need to do this is that the master copy is going
to be changed, (I.E.: added to and some deletions so if it is linked to the
location such A1 or A2 then whatever moves down or up will be the wrong
information. I have in my worksheet Standard numbers such as 12.3.5 , I would
like to just link to the standard # so that if it gets moved the information
in my other worksheet that I have it linked to will stay the same or update
when my master is updated. I hope this makes sense.
Thanks in advance for any help.
 
C

charob

Thanks for getting back to me Sean I will certainly try that. I have one
more question would the formula be =indirectmaster!(A1)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Rows instead of just cells. 1
I need a cell to be blank. 4
linking a fixed cell 1
Linking cells between sheets 4
Linking sheets how do I display the zeros (0) as blank cells 1
Linking Cells 2
Excel Linking (I think) 17
How do you assign a Workbook Location Path to a cell? 1

Top