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