Hi Chuck

Great to read that I did something good 2 years ago <vbg

Google is your best friend


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message ...
Hi Ron.........

I had a similar problem today, only I needed 20 or's on the Autofilter. I
dug this solution of yours out of the archives and it worked swell........bet
you never thought that when you offered it on 9/1/05 that you would actually
solve a problem for someone 2 years later.........

Thanks,
Chuck, CABGx3




"Ron de Bruin" wrote:

Hi Alex

I have a typo in the formula, this one is OK (one " to much in the other one)

=OR(A2={"ERP","PM","HPW","OJT","SBR","LD","CFT"})



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi Alex

For example your data range is A1:G100
Row 1 are headers and you want to check A2:A100 for the Criteria

In H1 enter header text
In H2 copy this formula and copy it down to H100
=OR(A2={"ERP","PM","HPW","OJT","SBR"","LD","CFT"})

Now you can use AutoFilter on column H for True or False


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alex" wrote in message ...
Thanks a lot, Ron.

Could you please explain how to create this helper column.

"Ron de Bruin" wrote:

Hi Alex

You can use Advanced Filter to do this
http://www.contextures.com/xladvfilter01.html

Or insert a helper column and AutoFilter on that column
=OR(A1={"A","B","C","D","E"})

EasyFilter have 5 options
http://www.rondebruin.nl/easyfilter.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alex" wrote in message ...
I'm applying the following filtering:
Worksheets("Sheet1").Select

Selection.AutoFilter Field:=1, Criteria1:="=ERP", Operator:=xlOr, _
Criteria2:="=PM" ' Working well

But, I need more criterias there such as:

Selection.AutoFilter Field:=1, Criteria1:="=ERP", Operator:=xlOr, _
Criteria2:="=PM" ', Operator:=xlOr, Criteria3:="=HPW" , _
Operator:=xlOr, Criteria4:="=OJT", _
Operator:=xlOr, Criteria5:="=SBR", _
Operator:=xlOr, Criteria6:="=LD", _
Operator:=xlOr, Criteria7:="=CFT"

How could I do it?

Thanks