I am trying to create a filter that will select 4 different parts.
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:
ActiveSheet.Range("$A$1:$N$6000").AutoFilter Field:=4, Criteria1:="=*A717*", _
Operator:=xlOr, Criteria2:="=*XBEA*"
Can I add more criteria to this formula. Right now this works for finding the two parts.
Best
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:
ActiveSheet.Range("$A$1:$N$6000").AutoFilter Field:=4, Criteria1:="=*A717*", _
Operator:=xlOr, Criteria2:="=*XBEA*"
Can I add more criteria to this formula. Right now this works for finding the two parts.
Best