Hyperlink to cell within a sheet breaks when cells are sor..

CJ55 · External Since: Nov 03, 2009 Posts: 1

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!

Jacob Skaria · External Since: Mar 04, 2009 Posts: 441

=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!