Activate a filter using multiple Data Validation drop down lists

I've been searching all over the Internet and I can't find a definitive answer about whether or not a VBA advanced filter can be activated via the values in one or more data validation list dropdowns.

I currently have the following code but it doesn't work based on the DV lists at all no matter how I modify it. It does run without error and does filter to one specific record each time but doesn't change at all no matter what the DVs are set to. Along with this, I should say that I would also like to make it so the filter icons do not show up on the column headers. If there is any way to tell them to not display, that would be great too.

Please Login or Register  to view this content.

B3 is the location of the first data validation list and D3 is the location of the 2nd one. I want these to be dynamic so the dropdowns can be changed and then they just push a button to run the above macro to change the current filter to whatever is in the DV dropdown cells. If the filter can be activated just by changing the data selected in the DV, I would consider that the best case scenario if it's at all possible.

Yes, I already know that I could just use the filter from the Home > Editing menu.

Thanks for your help!

I finally found it. This works perfectly combined with appropriate macros to set and remove filters, and insert or delete selected rows. Filters can be activated from one criteria, the other, or both of them together OR many of one column and of all of the others if you choose to go that far to build it out.

http://www.youtube.com/watch?v=LRDTWDuTSNY