Multiple Autofileter in Excel macro

[bpy2012]

Hi Team,

I use to run a report daily of my clients. Hence i am trying to create a Macro for the same. While creating i face some difficulty.

My data includes Name of clients in 1 coloumn and there comments in 2 coloumn and so on...

I want macro to search a specific word for example "Good", "Bad", "Average" and so on from the coloumn "Comments".
But i am unable to provide the Autofilter criteria more than 2. Hence please advise me what will be the VBA code for macro where i can provide multiple autofilter words.

 

[JoeMo]

You can use an array to if you have multiple criteria. Something like this, where Field 2 contains the comments:

ActiveSheet.Range("$A$1").CurrentRegion.AutoFilter Field:=2, Criteria1:=Array("Good", "Bad", "Average"),Operator:=xlFilterValues

You may need to add wildcards if your criteria key words are part of longer strings.