How can I make a Hyperlink relative?

  • Thread starter Thread starter griff
  • Start date Start date
G

griff

Please help. I have a workbook that has a sheet that has
hyperlinked categories that link within the document. The
hyperlinks work great but if you were to add lines or do
anything to take the information and move it to a
different cell reference then unlike a formula, the
hyprlink stays fixed to the cell number and dosent move
with the information. So, is there a way to keep the
hyperlink relative with the information in a cell and not
just the cell number??

help help help
 
Try using this formula:


=HYPERLINK("[book1]Sheet1!"&ADDRESS(ROW(C3),COLUMN
(C3),4),"Sheet2!A1")

C3 in Sheet 1 in book1 is the cell referenced by this
formula, however, if the location of data in C3 moves
because of inserted rows or columns or cells, the formula
will change accordingly.

Cheers
Juan
 
Back
Top