Hyperlink to the cell from where it was previously

No ideas come to mind from your example.

Attach a sample workbook. Make sure there is enough data for you to demonstrate what is needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

The only way to "store" a random row reference to down below is to use VBA.

We can store the "row where we clicked a hyperlink" in a public variable, so we can return to it later using a specific method.

When you click a hyperlink in column I the clicked cell "row" is memorized, then the hyperlink jumps you up.

1) Put the word RETURN in column I on the rules up above where you'd like the ability to jump back down.

2) To insert this code, right-click the tab name and select VIEW CODE, this opens the VBA Editor and shows you that sheet module.

3) Paste in this sheet code:

Please Login or Register  to view this content.

4) Close the vbeditor and save your workbook as a macro-enabled workbook.... *.xlsm

5) Now click on a hyperlink down below to jump up, the double-click the word "Return" on that upper rule and it will jump you back down.

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.