open a new worksheet

S

sarah

when a user selects a option from a drop down menu on my worksheet I want excel to move to the worksheet that refers to that selection- how can I do this?
 
T

Tom Ogilvy

To make the information appear in sheet1, use the indirect function to build
a dynamic reference.
--
Regards,
Tom Ogilvy

sarah said:
when a user selects a option from a drop down menu on my worksheet I want
Click to expand...
excel to move to the worksheet that refers to that selection- how can I do
this?
 
Top