Hi,

Check this link for assistance.

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu


"SGE" wrote:

I have a workbook that has over 80 worksheets in it and I am creating a
summary page. Currently I use the scroll bar to slide between the various
sheets to cut and paste the information and then create the hyperlinks. It
would be more efficient at this stage if I had a dropdown box similar to the
named field dropdown box. Is there a way to create a dropdown option so you
can navigate quickly to the individual worksheets that are created within a
workbook?
--
SGE