I have a spreadsheet of servers & their associated databases. When I click on a database there is a hyperlink that takes me to another worksheet with more information on that particular server & database. Plus I also have a “Sort by Server” & a “Sort by Database name” button. These buttons run macros that highlight the spreadsheet & do a sort by the corresponding cell row. Those buttons work great. But when I run the sort, the hyperlink doesn’t follow the value it’s linked too.
For example…The word “Names” in cell A23 is hyperlinked to worksheet #3. That works fine. But if I resort by database name or server (or whatever the opposite is at that time), it changes the value but the hyperlink doesn’t follow the new sort. “Names” may be in B17 now. But the hyperlink in A23 is still linked to “Names” and perhaps should be now, “City” going to worksheet #6.
Is there a way to make the hyperlink follow the sort?
Hope this makes sense. Thank you for your time.
John
