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

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

You can do this a couple of ways. One option is to use macros but another
option is to use hyperlinks.

Insert>Hyperlink 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