Dave,

This seems like it would solve the same problem I am having. The only
difference is that I have the hyperlink in column A which links to a
different file in a different location. The hyperlink has path coded into it
with a reference to column B of the same row for the file name. There are
over 14,000 rows which need to be sorted and have the hyperlink point to the
correct file instead of the original.

For example, I currently have the hyperlink in cell A3 as follows (SCAN2 is
the file name):

=HYPERLINK("\\network\documents\drawings\scans\all \"&SCAN2!B3&".tif","View
Scan")

How would I adjust your hyperlink formula to use it with the path coded and
the reference to the cell in the same row in column B for the file name?

Thank you very much.

"Dave Peterson" wrote:

I'd drop the insert|hyperlink version of the hyperlinks and use a worksheet
formula in an adjacent cell:

If your worksheet name were in A2, you could put:

=HYPERLINK("#"&CELL("address",indirect("'" & a2 & "'!A1")),"Clickme")

Then make sure you include both columns when you sort.

Andybanker wrote:

Worksheet 1 is a table to list up to 100 prospective customers. Worksheets
2-101 are prospective customer profile forms. Each name cell on Worksheet 1
is hpyerlinked to a unique profile. The problem is when I re-sort the list
of names on worksheet 1, the hyperlinks remain with the cells and do not
"follow" the new location of the name caused by the sort. How can I get a
hyperlink (or some alternative) to stay with the row as it gets resorted?

--

Dave Peterson