| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create a dropdown box that also filters information
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i create a dropdown box that also filters information
Please refer the below link by Debra Dalgleish
on the subject "Excel -- Data Validation -- Dependent Dropdowns from a Sorted List " http://www.contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "Lynda" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link information form a dropdown list | Excel Discussion (Misc queries) | |||
| How to create references with a dropdown? | Excel Discussion (Misc queries) | |||
| how do I create a dropdown menu | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
| Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions | |||
Linear Mode
