SOLVED

Excel Hyperlinks

%3CLINGO-SUB%20id%3D%22lingo-sub-2299059%22%20slang%3D%22en-US%22%3EExcel%20Hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299059%22%20slang%3D%22en-US%22%3E%3CP%3EHi.....%3C%2FP%3E%3CP%3EI'd%20like%20to%20use%20a%20Hyperlink%20to%20a%20different%20sheet%20but%20move%20down%20the%20cells%20automatically%3C%2FP%3E%3CP%3ESo%2C%20in%20the%20first%20cell%20in%20sheet1%20I'd%20like%20to%20Hyperlink%20to%20Sheet2%20cell%20A1%3C%2FP%3E%3CP%3EBut%20then%26nbsp%3Bin%20the%20second%20cell%20in%20sheet1%20I'd%20like%20to%20Hyperlink%20to%20Sheet2%20cell%20A2%3C%2FP%3E%3CP%3EHow%20do%20i%20do%20this%20please%3F%3C%2FP%3E%3CP%3EMany%20Thanks%3C%2FP%3E%3CP%3ETony%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2299059%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2299090%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1038692%22%20target%3D%22_blank%22%3E%40Tony-Morris85%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20enter%20the%20following%20formula%20in%20Sheet1%20cell%20A1%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DHYPERLINK(%22%23Sheet2!A%22%26amp%3BROW())%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2301400%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2301400%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%20That%20works%20perfectly%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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

2 Replies
best response confirmed by Tony-Morris85 (New 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