drop down box linking worksheets

J

justinjamesaaron1

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.
 
D

Dave Peterson

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]
 
Top