HYPERLINK - Jump to another sheet in the same workbook

[Tor Einar]

My workbook's name is Test.xls. By clicking a specific cell in sheet 1, I
want Excel to jump to sheet 3 in the same workbook. What is wrong with my
formula:
=HYPERLINK("(Test)Sheet3!";"Click")

 

[Mike H]

Hi,

Why don't you simply select the cell then

Insert|Hyperlink
Select Place in this document and select your sheet.
You can specify a particular cell and text to display.

Mike

 

[Pete_UK]

Try it this way:

=HYPERLINK("#"&"sheet3!A1","click")

# means current workbook, and you need to specify the cell that you
are jumping to.

Hope ths helps.

Pete

 

[Dave Peterson]

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 "sending" sheet.