Using Hyperlinks

[derekm]

I have a workbook with approx. 100 separate sheets (1 for eac
customer). Is there any way of setting up an introductory screen tha
would allow a user to select a customer from a drop down list, tha
would automatically move them to the appropriate worksheet. (eg. I
customer aa1 is selected excel would automtically move to a given cel
reference on worksheet aa1).

Thanks in advance.

Dere

 

[JMay]

Take a look here:

http://www.mcgimpsey.com/excel/listnames.html

 

[Frank Kabel]

Hi
as a starting point:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[JMay]

Sorry, what I gave you is the wrong ref site/subject.. The one Frank gave
you [TOC] is the one you need..

Take a look here:

http://www.mcgimpsey.com/excel/listnames.html