Forum Discussion
Solved
Excel Hyperlinks
Hi.....
I'd like to use a Hyperlink to a different sheet but move down the cells automatically
So, in the first cell in sheet1 I'd like to Hyperlink to Sheet2 cell A1
But then in the second cell in sheet1 I'd like to Hyperlink to Sheet2 cell A2
How do i do this please?
Many Thanks
Tony
For example, enter the following formula in Sheet1 cell A1:
=HYPERLINK("#Sheet2!A"&ROW())
Fill down.
5 Replies
For example, enter the following formula in Sheet1 cell A1:
=HYPERLINK("#Sheet2!A"&ROW())
Fill down.
- A similar scenario but I want to hyperlink to a cell in the same worksheet. ie From cell R3 to Q75 and fill down the formula to 34 rows. (R4 to Q76 etc.) Tried =HYPERLINK( "#Q75!Q"&ROW()) Returns Reference isn't valid.
Let's say the sheet is named Sheet 1. In R3:
=HYPERLINK("#'Sheet 1'!Q"&ROW()+72)
Fill down.
Thank you HansVogelaar That works perfectly
