Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to set up a macro that will initiate a pop up box that has all of
my column headers in it. Then I can go through the list and select which filters I use on any or all of the columns. Once I pick all the criteria I want the macro runs and returns my data for all rows that match the filters. Essetially its the same as going through column by column and selecting different filters until I get down to a small list. eg. column 1 (Name), Column 2 (State), Column 3 (vehicle type), Column 4 (vehicle make) ... The popup would prompt me to select filters and I could pick Truck (col 3) and Toyota (col 4). Or choose state and toyota (Etc etc etc). Then have the correct autofilters automatically run. Thanks in advance for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro, AutoFilter... | Excel Discussion (Misc queries) | |||
AutoFilter Macro | Excel Worksheet Functions | |||
Autofilter Macro Help | Excel Discussion (Misc queries) | |||
Excel VBA assistance for a noobie | Excel Programming | |||
autofilter using macro | Excel Programming |