VBA Filtering with multiple criteria

Jvalades

New Member
Joined
Jul 28, 2016
Messages
40
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
 
Container ID
Direct sale prepay
Direct sale LC
Direct sale LC
Direct sale prepay
Direct sale prepay
Direct sale prepay
Direct sale prepay
Direct sale LC
Direct sale prepay
Direct sale prepay
Direct sale prepay
Direct sale LC
KUHNING/invoice only
Direct sale LC DGR
sekumel // 0739
MINSCLA
rodejan / Direct Sal
dambada AIR DGR
costlav
rodejan Direct Sales
heppmar
rodejan / Direct Sal
rodejan / Direct Sal
rodejan DG /Direct S
<colgroup><col width="177" style="width: 133pt; mso-width-source: userset; mso-width-alt: 6286;"> <tbody> </tbody>
GROSSTE DG
rodejan/direct Sales
golador01
rodejan / Direct Sal
rodejan / Direct Sal
DIRECT SALES DGR BAT
ARDEDAN
rodejan / Direct Sal
GROSSTE DG
golador01
I0701/06 AIR DGR BAT
costlav
costlav
ENGLOLG
GROSSTE DG
I0701/02
ARDEDAN
I2112/06
MINSCLA
costlav
schwseb
I0363/06
I0308/06
MINSCLA
sekumel //
I3218/Sea/Stator
MINSCLA
ENGLOLG
I3751/06/TRUCK
ENGLOLG
BOTDL - direct sales
ZMS / 06 / Direct Sa
ZMS / 06 / Direct Sa
Direct Sales
Direct Sales ZM
costlav
DAMBADA
golador01
ENGLOLG
costlav
costlav
costlav
ENGLOLG
ARDEDAN
costlav
golador01
costlav
ARDEDAN
golador01
MINSCLA
ARDEDAN
ARDEDAN
MINSCLA
ENGLOLG
costlav
GROSSTE DG
dambada AIR DGR
schwseb
sekumel //
schwseb
sekumel //
I0145/04
schwseb
GROSSTE DG
sekumel //
schwseb
I4092/04
sekumel //
<colgroup><col width="177" style="width: 133pt; mso-width-source: userset; mso-width-alt: 6286;"> <tbody> </tbody>


<tbody>
</tbody>
im havin the sae quetion, my data ha difirent names and i wan to filters multipal criteria on th same column..as above and want to filter only "Direct sale" and "direct s", "DS"Please guide
 
Upvote 0

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,213,538
Messages
6,114,217
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top