Using Hyperlinks

D

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
 
Top