Like filter: Please advice

[pedie]

Can we filter with like values? I just donno what to do
Please advice:

[/FONT]
[FONT=Courier New]Range("B1:E12").AutoFilter
ActiveSheet.Range("$B$1:$E$12").AutoFilter Field:=1, Criteria1:=Array( _
        "Userid" & "*", "Name" & "*", "KX1"), Operator:=xlFilterValues

 

[meldoc]

Hi Pedie

Not sure I follow, maybe this.

Excel Workbook
	B	C	D	E	F	G
1	test1	test2	test3	test4		Bob
2	Bob w	Data1	Data1	Data1
3	v Bob	Data2	Data2	Data2
4	Bobs	Data3	Data3	Data3
5	Ted	Data4	Data4	Data4
6	Jim	Data5	Data5	Data5
7	Bobb	Data6	Data6	Data6
8	Bob88	Data7	Data7	Data7
9	7Bob	Data8	Data8	Data8
Sheet1

Excel 2010<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>  Range("B1:E1").AutoFilter<br>  ActiveSheet.Range("$B$1:$E$12").AutoFilter Field:=1, _<br>    Criteria1:="*" & Range("G1") & "*", Operator:=xlFilterValues<br><SPAN style="color:#00007F">End</SPAN><SPAN style="color:#00007F">Sub</SPAN><br><br></FONT>

 

[pedie]

Brian, thanks alot! it works...but can i add one more like critiria like the one you have...
like *bob*
then maybe like *Ped*

Thanks again

 

[meldoc]

Ok try,

Excel Workbook
	B	C	D	E	F	G
1	test1	test2	test3	test4		Bob
2	Bob w	Data1	Data1	Data1		Ped
3	v Bob	Data2	Data2	Data2
4	Bobs	Data3	Data3	Data3
5	Ted	Data4	Data4	Data4
6	Jim	Data5	Data5	Data5
7	Bobb	Data6	Data6	Data6
8	Bob88	Data7	Data7	Data7
9	7Bob	Data8	Data8	Data8
10	Ped	Data8	Data8	Data8
11	t Ped	Data8	Data8	Data8
12	Ped ~	Data8	Data8	Data8
Sheet1

Excel 2010<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>  Range("B1:E1").AutoFilter<br>  ActiveSheet.Range("$B$1:$E$12").AutoFilter Field:=1, _<br>    Criteria1:="*" & Range("G1") & "*", Operator:=xlOr, Criteria2:="*" & Range("G2") & "*"<br><SPAN style="color:#00007F">End</SPAN><SPAN style="color:#00007F">Sub</SPAN></FONT>