Apr 27 2021 11:07 AM
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
Apr 27 2021 11:21 AM
SolutionFor example, enter the following formula in Sheet1 cell A1:
=HYPERLINK("#Sheet2!A"&ROW())
Fill down.
Nov 03 2022 01:49 AM
Nov 03 2022 03:51 AM
Let's say the sheet is named Sheet 1. In R3:
=HYPERLINK("#'Sheet 1'!Q"&ROW()+72)
Fill down.
Apr 27 2021 11:21 AM
SolutionFor example, enter the following formula in Sheet1 cell A1:
=HYPERLINK("#Sheet2!A"&ROW())
Fill down.