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..
|