I am trying to create a filter that will select 4 (or more) different parts based on the name of the part. Ex. Tea123
another constraint is: Sometimes a part will be added with a similar name so I cannot specify the exact name.
So what I started with is:
[COLOR=#333333]ActiveSheet.Range("$A$1:$N$6000").AutoFilter Field:=4, Criteria1:="=*A717*", _[/COLOR] [COLOR=#333333]Operator:=xlOr, Criteria2:="=*TEA123*" [/COLOR]
Can I add more criteria to this formula. Right now this works for finding any part that contains "A717", or "TEA123" but I need this to also find a few other that have different names.