HYPERLINK

[stew]

WHAT AM I DOING WRONG WITH THIS FORMULA. i AM ATTEMTING TO JUMP FROM ONE
WORKSHEET TO ANOTHER WITHIN THE SAME WORK BOOK
=HYPERLINK("[The Road accounting program]Invoices to Promoters!g11", G11)

THANKS FOR LOOKING

STEW

 

[Warren Easton]

Hi Stew,

If the hyperlink doesn't work I usually right click on the Fast Forward
arrow in the bottom left hand corner to jump between worksheet.

 

[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 linked sheet.

WHAT AM I DOING WRONG WITH THIS FORMULA. i AM ATTEMTING TO JUMP FROM ONE
WORKSHEET TO ANOTHER WITHIN THE SAME WORK BOOK
=HYPERLINK("[The Road accounting program]Invoices to Promoters!g11", G11)

THANKS FOR LOOKING

STEW