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