Besoin Aide MACRO FILTRE AVANCE MULTI CRITERES avec Criteres > & < .

Jeanluc31470 

I like the expression "VBA speaks America" ... that's very true

To add,

Extracting records based on multiple criteria can be done in so many ways:

• Using advanced filter in VBA as you did
• Using the Find command and Looping over the records in VBA
• Recording a Macro for Advanced Filter in regular Excel
• Using Formulas and Functions (which is dynamic)

I am attaching herewith a sample File where I used 3 of these methods on different sheets >> Change the criteria in Row 2 from the drop list and records are automatically extracted.

You can also watch my tutorial on how I did it by following the link:

https://www.youtube.com/watch?v=9yhbh6l_rag

Hope that helps

Bonne Chance  🙂 

Nabil Mourad