Hi All!

I am trying to dump records from one worksheet into another, but am trying
to look for 8 different OR's in one go, as I would like the data to be pasted
as one block.

I have used so far:

Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:="*andy*", Operator:=x1Or, _
Criteria2:="*bob*", Operator:=x1Or, _
Criteria3:="*kat*", Operator:=x1Or, _
Criteria4:="*paul*", Operator:=x1Or, _

and so on .....


Being the dunce that I am, it doesn't work - any help or paracetomol would
be greatly appreciated.

Thanks

Andy