Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to jump to a worksheet from a contents sheet
I have set up a spreadsheetto monitor a budget. This has a summary sheet and
several worksheets that link data back to the summary. EG Summary repairs is linked to external reps, internal reps etc. I want to be able to click on a cell set up in a spare column iin the summary sheet and jump straight to its sub worksheet. I might even have to set up a contents sheet but I do not know how to link the "jump" to each individual worksheet. Any ideas anyone. John Church |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to jump to a worksheet from a contents sheet
See "Hyperlink" in Excel Help
I think you could probably use either the HYPERLINK function or actually insert hyperlinks in your TOC. Post back with any questions. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "John C" wrote: I have set up a spreadsheetto monitor a budget. This has a summary sheet and several worksheets that link data back to the summary. EG Summary repairs is linked to external reps, internal reps etc. I want to be able to click on a cell set up in a spare column iin the summary sheet and jump straight to its sub worksheet. I might even have to set up a contents sheet but I do not know how to link the "jump" to each individual worksheet. Any ideas anyone. John Church |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to jump to a worksheet from a contents sheet
You can do this a couple of ways. One option is to use macros but another
option is to use hyperlinks. InsertHyperlink Select "Place in this document" and then type where you want to jump to. You can then set up various heyperlinks to jump between sheets. Ian "John C" wrote: I have set up a spreadsheetto monitor a budget. This has a summary sheet and several worksheets that link data back to the summary. EG Summary repairs is linked to external reps, internal reps etc. I want to be able to click on a cell set up in a spare column iin the summary sheet and jump straight to its sub worksheet. I might even have to set up a contents sheet but I do not know how to link the "jump" to each individual worksheet. Any ideas anyone. John Church |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Using cell contents to reference worksheet names | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Numbers from seperate worksheet to common sheet | Excel Worksheet Functions |