Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating own filters
How would i go about creating a sheet which contains dropdown lists t
filter data. i have a workbook with multiple sheets the first of whic contains a database linked by a query from access to excel. what i wan to do is to create a user interface which the user will be able t select which data from the database the user wants to see. An suggestions would be much appreciated -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating own filters
Alistair,
Sounds like a candidate for Data Validation. Take a look at Debra Dalgleish's site at http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "alistair01 " wrote in message ... How would i go about creating a sheet which contains dropdown lists to filter data. i have a workbook with multiple sheets the first of which contains a database linked by a query from access to excel. what i want to do is to create a user interface which the user will be able to select which data from the database the user wants to see. Any suggestions would be much appreciated! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use "OR" in two auto-filters/custom filters? | Excel Discussion (Misc queries) | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Creating a function to test for the filters applied... | Excel Programming |