Link in worksheet

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi. I have a worksheet where I have a hyperlink to cell A61 in that worksheet.

I am going to be copying several copies of this worksheet in the same
workbook. When I do this, the link refers to the original worksheet.

Is there a way to have the link point to a cell in the active worksheet so
that I don't have to go in and edit the link in each and every copy?

Thanks,
Mike.
 
Use INDIRECT()

Suppose in A1 you have the Worksheet Name. The below will return the cell
value of A2 from the worksheet mentioned in A1

=INDIRECT(A1&"!" & "A2")



If this post helps click Yes
 
You could use the =hyperlink() worksheet function:

=HYPERLINK("#C5","Click me")

But I'd use one of these...

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.
 
Oops..Try the below

=HYPERLINK("#"& CELL("address",Sheet1!A61),"LINK")

If this post helps click Yes
 
Back
Top