link two cells

  • Thread starter Thread starter viilis
  • Start date Start date
V

viilis

can anybody tell me a good way to link cells on two different worksheet
to each other so that when the user clicks on a cell/button on sheet 1
he/she will automatically be taken to a certain cell in sheet2?

I am using hyperlinks for that at the moment, but updating(for exampl
when the name of sheet2 changes) them is a real pain, because one ha
to go through each hyperlink individually...


thanks for any help
 
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)

I bet a version of the bottom two will fix the problem of renaming worksheets.
 
Back
Top