HyperLinkDumbIam

  • Thread starter Thread starter NotGood@All
  • Start date Start date
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)
 
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.
 
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.
 
Back
Top