HyperLinkDumbIam

N

NotGood@All

I have 2 worksheets, I want to link say "f5" in worksheet1 to "A1" in
worksheet2 but can't get the code correct, my latest effort is - in the "Type
the cell reference:" I used =hyperlink(Sheet1!$F$5,Sheet2!$A$1)
 
A

Alan Moseley

I don't think you need a formula. Click in the cell you want the hyperlink
to appear. Now from the top menu click 'Insert' then 'Hyperlink'. Click
'Place In This Document' from the menu on the left, click the destination
sheet in the middle of the windows, and finally change the cell reference at
the top.
 
D

Dave Peterson

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the linked sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top