Links

  • Thread starter Thread starter The Prices
  • Start date Start date
T

The Prices

I have created a link (reference only) from one tab to a second tab cell. Is
it possible to do something to that link, or create a different type of link,
so that when I click on it it will go the the cell in the second tab, similar
to a hyperlink?
 
Why not just use a hyperlink?

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)

The thing that's very nice about David's syntax is that if you insert or delete
rows/columns in Sheet3, then the formula will point to the new location.

You could also use this syntax:
=HYPERLINK("#Sheet3!C5","Click Here")

Will always point at C5 of Sheet3--no matter if you insert/delete rows or
columns--or delete Sheet3!!!

So you'll want to choose the one that fits your requirements.
 
Thanks. That worked great!

Dave Peterson said:
Why not just use a hyperlink?

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)

The thing that's very nice about David's syntax is that if you insert or delete
rows/columns in Sheet3, then the formula will point to the new location.

You could also use this syntax:
=HYPERLINK("#Sheet3!C5","Click Here")

Will always point at C5 of Sheet3--no matter if you insert/delete rows or
columns--or delete Sheet3!!!

So you'll want to choose the one that fits your requirements.
 
Another method.

Right-click on the cell and Hyperlink>Place in This Document.

Pick the sheet and cell and OK.

You could give the cell a descriptive text also in Text to Display


Gord Dibben MS Excel MVP
 
Back
Top