G Guest Oct 26, 2003 #1 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?
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 Oct 27, 2003 #2 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?
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?
