Hi
The following code is quite straight forward and looks for 2 criteria using a filter within some data but I need it to look for more than 2 criteria now as the report is growing...
Selection.AutoFilter Field:=10, Criteria1:="=SERCO", Operator:=xlOr, _
Criteria2:="=NG"
I have tried adding a 3rd criteria based on the code above as show below
Selection.AutoFilter Field:=10, Criteria1:="=SERCO", Operator:=xlOr, _
Criteria2:="=NG", Operator:=xlOr, _ Criteria3:='=NSC"
but it won't work. Any help appreciated
Thank you in advance
Kerry
The following code is quite straight forward and looks for 2 criteria using a filter within some data but I need it to look for more than 2 criteria now as the report is growing...
Selection.AutoFilter Field:=10, Criteria1:="=SERCO", Operator:=xlOr, _
Criteria2:="=NG"
I have tried adding a 3rd criteria based on the code above as show below
Selection.AutoFilter Field:=10, Criteria1:="=SERCO", Operator:=xlOr, _
Criteria2:="=NG", Operator:=xlOr, _ Criteria3:='=NSC"
but it won't work. Any help appreciated
Thank you in advance
Kerry