Hyperlink problem

[Meitheal]

Hi,
I'm trying to hyperlink cells in two worksheets in a way that keeps the cell entries (data) linked when I use the sort function. Otherwise I end up with hyperlinks to cells that are irrelevant after sorting. Can you help? Many thanks!

 

[Jerry Sullivan]

Hi and Welcome to the Board,

I'm not aware of a simple way to do what you describe, since Hyperlinks that have Cell Addresses as Targets don't follow the cell entries (data) when they are moved through sorting.

If you have unique values within a specified column, you could use a Dynamic Named Range (DNR) to "find' the data entry, then have your Hyperlink point at that DNR.

 

[Meitheal]

Hi Jerry,
thank you for the help with this I will try that!
best,
M