filter data based on text

[baskar5353]

hi
i'm now for vba in column c it contains sentences i want to filter the data which have OLA and ACK. filter it and copy coresponding rows and column into new sheet
e.g
Priority 4 Response OLA
Priority 4 Response OLA
Priority 4 Response OLA
Priority 3 Resolution ACK
Priority 4 Response OLA
Priority 4 Response SLA
Priority 4 Response OLA
Priority 4 Response SLA
Priority 4 Response OLA
column header is SLA_ Name
i have attached sample workbook here see in sheet2 filter data

 

[Marc L]

Hi,

no data with « OLA and ACK » ! Maybe it's « OR » and not « and » !
« into new sheet » : where ?!

So attach a correct workbook or well explain your need …

First, try filter or advanced filter !
​

 

[baskar5353]

new sheet want to create within same workbook name as worksheet as System repsones
OLA and ACK it contains in column "C" refer in book
OLA and ACk contains withPriority 3 Resolution ACK
Priority 4 Response OLA like this i want to filter these two work which contain want to filter the coresponding colums and row dat also

 

[Marc L]

Seems no such data in attached workbook column C …

So without anyone else answer, post workbook with source data in Sheet1
and desired result in Sheet2 according to source data from Sheet1,
should be easier for understanding !

But youl could resolve yourself just by using a filter or an advanced one …
​

 

[baskar5353]

i have try this "ActiveSheet.UsedRange.AutoFilter Field:=3, Criteria1:="=*OLA*", Operator:=xlAnd"
but it was filtering only "OLA" when i give 2criteria is not working
" ActiveSheet.UsedRange.AutoFilter Field:=3, Criteria1:=Array("OLA*", "ACK*"), Operator:=xlOr" its not working

 

[Marc L]

OLA* means starting with OLA like OLAF for example !
​