I have made a Macro script to make my build process much easier. It works perfectly, but I want to take it a step further and I am stuck!

I have gotten to the point of pulling out the bad criteria that I don't want.

2 Examples below.
1) I don't want Food Service, BUT I do want the supply/equipment/product for the food service industry.
2) I don't want Farm Service, BUT I do want the supply/equipment/product for the farm service industry.

I am wanting to add an exception to my criteria macro, so if the keyword supply or equip ect... is in that "range" it will be kept.

(my script)
ActiveSheet.Range("$A$1:$K$2182").AutoFilter Field:=2, Criteria1:= _
"=*food serv*", Operator:=xlAnd
Selection.ClearContents
ActiveSheet.Range("$A$1:$K$2182").AutoFilter Field:=2, Criteria1:= _
"=*farm*", Operator:=xlAnd
Selection.ClearContents

TIA! Newer to macro scripting!