Linking cells to worksheets

  • Thread starter Thread starter Mark G
  • Start date Start date
M

Mark G

I'm an idiot because I'm sure there is a simple solution that escapes me. I
would like to link a cell to a worksheet. Hopefully by clicking the cell on
the front or first page of a workbook it will take me to the worksheet I want
to view. Kind of like an interactive index....
 
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.
 
Back
Top