Autofilter macro for noobie
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.
|