Trouble with Sorting Hyperlinks
 

Without going into (hopefully) a huge amount of detail:

I have a hyperlink in SHEET1 that points to a specifi cell in SHEET2. The
reference looks like:
SHEET2!A3

Now, I sort SHEET2. The hyperlink still points to cell A3, which is now in
A17.

Is there any way to make the hyperlink follow the sort?

TIA.
...Jim..

Trouble with Sorting Hyperlinks
 

I think you'll have better luck if you use the =hyperlink() worksheet function
(in an adjacent cell) instead of the insert|hyperlink version.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)



Jim S wrote:

Without going into (hopefully) a huge amount of detail:

I have a hyperlink in SHEET1 that points to a specifi cell in SHEET2. The
reference looks like:
SHEET2!A3

Now, I sort SHEET2. The hyperlink still points to cell A3, which is now in
A17.

Is there any way to make the hyperlink follow the sort?

TIA.
..Jim..

--

Dave Peterson