| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HYPERLINK
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HYPERLINK
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. -- Regards Warren If this helps please click the Yes button. "stew" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HYPERLINK
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!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. stew wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Linear Mode
