Hello!
I want to create a hyperlink in excel that links to the contents of the cell, not to a cell itself.
For example, I have a hyperlink called "figure" that sends me to a cell that contains a figure, let's say B6. But then I sort my data in a different way and the figure ends up in cell C5. Then I would like "figure" to send me to C5. Is this possible?
I hope someone can help me, it's giving me headaches!
/Maria
Bookmarks