LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro, AutoFilter... Aline Excel Discussion (Misc queries) 1 July 27th 08 12:27 AM
AutoFilter Macro carl Excel Worksheet Functions 1 August 20th 07 08:34 PM
Autofilter Macro Help RonB Excel Discussion (Misc queries) 1 December 30th 04 01:34 AM
Excel VBA assistance for a noobie shaun nieves Excel Programming 7 May 31st 04 03:17 PM
autofilter using macro kkanil Excel Programming 1 October 29th 03 11:07 AM


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"