How can I make a Hyperlink relative?

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
 
J

Juan Sanchez

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
 

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

Hyperlink to cell within a sheet breaks when cells are sorted 1
Can you hyperlink to a hyperlink? 1
Hyperlinks 0
how do I drag and fill hyperlinks? 3
Hyperlink to a specific worksheet in another workbook. 0
Hyperlink to another worksheet to a absolute cell 1
Hyperlink text from linked workbook 1
Hyperlink Formula Problem 2

Top