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

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

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