Hyperlinks in 2003

[Joneye]

I hope this can be done,

I wish to place a hyperlink in cell a1 in tab1 and i wish this to link to tab2 cell a1.

I have tried but the only option I have is for in the same tab. USING EXCEL 2003

 

[Joneye]

I have found the below

=HYPERLINK("[Budget.xlsx]September!E56", E56)

To jump to a different sheet in the same workbook, include the name of the sheet, followed by an exclamation point (!), in the link. In the previous example, to create a link to cell E56 on the September sheet, include September! in the link.


Now the above works but I can not label the cell name i.e. CLICK here...

 

[Joneye]

Solved now.