Hyperlink result always in top left not frozen column

[Thanoswasrights2]

Hello,

I have buttons with hyperlinks in frozen columns A-B. Data sheet begins in Column C. Is it possible to make hyperlink always display result in top left after frozen columns?

[carlmon]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.