SOLVED

Excel Hyperlinks

Copper Contributor

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

5 Replies
best response confirmed by Tony-Morris85 (Copper Contributor)
Solution

@Tony-Morris85 

For example, enter the following formula in Sheet1 cell A1:

 

=HYPERLINK("#Sheet2!A"&ROW())

 

Fill down.

Thank you @Hans Vogelaar  That works perfectly

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.

@DAHAWOR1953 

Let's say the sheet is named Sheet 1. In R3:

 

=HYPERLINK("#'Sheet 1'!Q"&ROW()+72)

 

Fill down.

Of course - thank you for the speedy reply
1 best response

Accepted Solutions
best response confirmed by Tony-Morris85 (Copper Contributor)
Solution

@Tony-Morris85 

For example, enter the following formula in Sheet1 cell A1:

 

=HYPERLINK("#Sheet2!A"&ROW())

 

Fill down.

View solution in original post