drop down box linking worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a drop down box on 30 different worksheets so that when I want to go to a certain worksheet I can just look through the drop down list. I know how to create a drop dowwn list for a single worksheet, but not one like this. I have data for the last 24 weeks on different worksheets and I need this list. thanks.
 
Did you know that you could rightclick on the VCR like controls (to the left of
the worksheet tabs) and see a list of all the worksheets?

Another option is to add hyperlinks to each sheet. But I think I'd use a
toolbar. You could use it for more than this workbook and it wouldn't take up
real estate on each worksheet.

http://groups.google.com/[email protected]
 
You must log in or register to reply here.

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

Similar Threads

Create Drop Down Box populated by a List 1
Expanded Drop Down Box Question 2
Fill Drop Down with List 2
Filtered drop down list 2
Using drop down lists on protected worksheet 1
drop down list 2
Drop Down List Contains the List Header Row 1
how to show data in another cell from a drop down box 3

Back
Top