To view different sheets using a drop down list

L

Laila

Hi everyone,

I have five sheets. Lets say
1. Sales
2. Purchase
3. Marketing
4. Accounts
5. Stock

Note: The row and column titles are the same; data are resting on th
same cell position in all the 5 sheets.


And I have a blank sheet, lets call it *viewanswer*.


In the *viewanswer*, I need to create a drop down list to select whic
sheet I would like to see, instead of clicking the respective shee
name at the bottom.

Help is really appreciated
 
F

Frank Kabel

Hi
do you want to 'go' to this sheet or do you want to 'pull' soem data from
these sheets to your 'viewanswer' sheet?
 
M

Micke

Hi Laila!

Try this in your macro for the drop down list:

Sheets(Range("A1").Value).Select

Where Range A1 is the the linked cell from your drop downlist.

Regards///M
 
Top