Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Menu and multiple results
G'day,
I have a spreadsheet with multiple rows and columns. (name, location, service, business type). I want to have two drop down menus for location and service. Based on the combination selected I would like all rows that meet this criteria returned below the drop down menus. One sheet with all possible data results and another sheet with the drop down menus that would return the appropriate results. Any help would be greatly appreciated. Thanks, MB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Menu and multiple results
You can do this with programming. One of the sample files here may help
you get started: http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List by Category', or 'Product List by Week Number' Chewy wrote: G'day, I have a spreadsheet with multiple rows and columns. (name, location, service, business type). I want to have two drop down menus for location and service. Based on the combination selected I would like all rows that meet this criteria returned below the drop down menus. One sheet with all possible data results and another sheet with the drop down menus that would return the appropriate results. Any help would be greatly appreciated. Thanks, MB -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation drop down for multiple worksheets | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How to choose multiple itmes from a Pivot Table Page drop down men | Excel Discussion (Misc queries) | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
Multiple selections in a drop down menu | Excel Worksheet Functions |