I understand how to create a hyperlink to take me to other sheets using the hyperlink formula, but I become stuck with the next part. If I have headings in Row 1, I would like to be able to see which one was selected. For example, if we assume the columns are also the headings (heading A in A1, heading B in B2, etc.) and I select the hyperlink in cell F2, when it takes me to the next page, is there a way for it to list which was selected?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hyperlink formula reference
Similar threads
- Question
