Sorting Hyperlinks

[Guest]

When I sort a rows containing hyperlinks, the reference remains static at the previous cell address instead of moving relative to the data being sorted. Is there a way around this?

 

[Dave Peterson]

I like to use the worksheet function:

=hyperlink("http://www.microsoft.com","Microsoft.com")

then it'll sort nicely.