Row names will not move with sort

[Guest]

Each row in my summary table in Sheet1 is hyperlinked to a corresponding table in Sheet2 with additional details.

I need to move the rows in my summary table (Sheet1) and preserve the links to and from the details tables (Sheet2).

I found that I can move rows in Sheet1 with cut & insert and the hyperlinks are maintained. I can travel from a row in summary table (Sheet1) to details table (Sheet2) and back, even after the corresponding row (Sheet1) was moved.

But if I sort the rows in Sheet1 the links from Sheet2 back to corresponding rows in Sheet1 lead to presorted locations. Apparently this is because the Excel Names are not moved in a sort. They are moved in a cut & insert operation.

Is there a way to sort my summary table so that row names and anchored hyperlinks also move?

Is my database setup awkward in Excel and I need to use Access? I'm not familiar with Access. Excel is 2002 SP1. Thanks.

 

[Dave Peterson]

It sounds like you used Insert|Hyperlink to create the links.

Could you use the worksheet function:

=hyperlink()

instead?

(I don't know anything about Access.)