To view different sheets using a drop down list

  • Thread starter Thread starter Laila
  • Start date Start date
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
 
Hi
do you want to 'go' to this sheet or do you want to 'pull' soem data from
these sheets to your 'viewanswer' sheet?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Using drop-down lists 4
Drop Down with dynamic named range offsheet source list 14
Drop Down Lists 2007 10
Starting drop down lists at the top 1
Protecting Sheets with drop down boxes 1
Displaying drop down list arrows 2
Formatted cell column in drop down list 1

Back
Top