how do i create a dropdown box that also filters information

L

Lynda

How can I create a drop down list that also lets me filter information?
ie product sales for a particular venue. The list contains all venues but
when one is selected it shows only the information on the spreadsheet for
this one and I can choose select all to view all others.
I have done this before but was so long ago I cant remember. Any help
apreciated x
 

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

Help With MS Access 4
Creating a drop down which causes information to appear. 4
Dropdown List within a dropdown 1
How do I use advance filter correctly? 2
Filter Data using a drop-down list 2
How do I combine information from two separate spreadsheets 2
Excel 2003 filtering problems 2
filter help 8

Top