Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a file that contains two user-defined lists. When the user sets
values for these lists & clicks a macro button, I want the macro to go to the master data tab and filter the appropriate columns based on these values. (From there, I have additional code that does something else with the filtered data). I am unsure how to construct the code that filters multiple items from a list. Can someone lend some guidance on how to do this? (One other thing in case it matters---the user list may contain anywhere from 1-100 items) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter range based on results of multiple selections in a listbox | Excel Programming | |||
Display all pivottable filter selections | Excel Worksheet Functions | |||
Data validation list drop-down values based on prior selections | Excel Programming | |||
Filter Excel Pivot, based on user entry form | Excel Discussion (Misc queries) | |||
Pop Up box to filter based on User Criteria | Excel Programming |