Forum Discussion
Tony-Morris85
Apr 27, 2021Copper Contributor
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 i...
- Apr 27, 2021
For example, enter the following formula in Sheet1 cell A1:
=HYPERLINK("#Sheet2!A"&ROW())
Fill down.
HansVogelaar
Apr 27, 2021MVP
For example, enter the following formula in Sheet1 cell A1:
=HYPERLINK("#Sheet2!A"&ROW())
Fill down.
Tony-Morris85
Apr 28, 2021Copper Contributor
Thank you HansVogelaar That works perfectly