Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numerous OR criteria in a Filtered Macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numerous OR criteria in a Filtered Macro
try using the 'Advanced Filter' under Tools \ Filter rather than the
'Autofilter' option. Rob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numerous OR criteria in a Filtered Macro
AFAIK you can't. But you can put in a helper column (hide if desired)
=IF(OR(D1={"add","ddd","joe"}),1,"") and filter on that 1 criteria -- Don Guillett SalesAid Software "Andy Wilkinson" <Andy wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numerous OR criteria in a Filtered Macro
Here's a thought. Put this formula in D2
=OR(D2={"bob","andy","paul"}) and copy down, then filter on TRUE Selection.AutoFilter Selection.AutoFilter Field:=4, Criteria1:="TRUE" -- HTH RP (remove nothere from the email address if mailing direct) "Andy Wilkinson" <Andy wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
several links to filtered list each with differenct criteria | New Users to Excel | |||
Numerous criteria in sumproduct | Excel Worksheet Functions | |||
Problem in sending filtered data to numerous/different locations | About this forum | |||
Count Filtered Visible Items that Match Numeric Criteria between two ranges | Excel Worksheet Functions | |||
How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions |