Autofilter run by a VBA code

[Gladme]

Hello Board,

I have a macro automating several functions including oneadvanced autofilter. To run the autofilter
I have a criteria list of 6 variables (a table with 2 rowsand 6 columns while the top row is my data base table title). I run the macrowhen I have a specific value for each variable. My problem is for the case I wantto filter my data base table for more than one value of one of the variables. Toexplain more, my data base includes price of several goods and variables aretime, vendor name, type of good, etc. I want to run the macro to filter thedata base for a specific time, specific good but for three or more vendors. Howcan I define these values to be filtered by an advanced filter run by a macro?

Thanks in advance for your help.

 

[Yongle]

Have a look at this excellent tutorial which explains how to add multiple conditions for advanced filter
In principle, you need to duplicate your current row for each vendor and amend your VBA to match

 

[Gladme]

Thanks for your time and consideration