Hyperlink to cell within a sheet breaks when cells are sorted
 

How can I lock down (or make relative) a hyperlink? I'm adding hyperlinks
between Sheet 1 (Schedule) & Sheet 2 (2009 Projects); when I sort Sheet 2,
the hyperlink on Sheet 1 is no longer valid. For example, the text originally
contained in my hyperlink to '2009 Projects'!$A7 has now moved to A10 as a
result of being sorted.

How can I make the hyperlink stay in sync with the correct text/cell? I've
tried pasting as link, tried placing the $ in various places, to no avail.

Appreciate any suggestions!

Hyperlink to cell within a sheet breaks when cells are sorted
 

=HYPERLINK("#"&CELL("address",'2009 Projects'!A7),"Click me")

If this post helps click Yes
---------------
Jacob Skaria


"CJ55" wrote:

How can I lock down (or make relative) a hyperlink? I'm adding hyperlinks
between Sheet 1 (Schedule) & Sheet 2 (2009 Projects); when I sort Sheet 2,
the hyperlink on Sheet 1 is no longer valid. For example, the text originally
contained in my hyperlink to '2009 Projects'!$A7 has now moved to A10 as a
result of being sorted.

How can I make the hyperlink stay in sync with the correct text/cell? I've
tried pasting as link, tried placing the $ in various places, to no avail.

Appreciate any suggestions!