I want to jump to a worksheet from a contents sheet

J

John C

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
 
R

Ron Coderre

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
 
I

Ian P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top