Excel hyperlinks

  • Thread starter Thread starter Steve Burton
  • Start date Start date
S

Steve Burton

I am trying to produce a worksheet with hyperlinks in.
The problem is that due to the links being referenced to a
particular cell, when additional information is added the
cell reference changes.
How do I bookmark certain text to reference again for the
links so the when their cell reference changes the link
follows the text?

Hope that someone can help me.

Cheers

Steve
 
Steve Burton:

If all of your data is contained in one file, you will need to addres
formulas that contain '$' when hyperlinking.

For example, a cell on Sheet 1 pointing to =Sheet2!$E$7 will alway
produce whatever is found in the contents of cell E7 on Sheet 2 of you
worksheet. If you add or delete rows and columns, the pointer will no
move to the new location.

If you remove the dollar signs, any time that you make relocatio
changes to sheet 2, the pointer in sheet 1 will follow it.


If your data is contained in more than one file, have all of your file
OPEN when inserting or removing rows and columns and your pointers wil
follow to the new locations provided they do not contain any of those
signs.

Hope this helps
 
Back
Top