christchaaya
04-09-2013, 05:14 AM
Hi everyone.
I need to filter my table by keyword; this is what I did
ActiveSheet.ListObjects("Tabla1").Range.AutoFilter Field:=5, Criteria1:= _
"Special permit"
as you can see I'm filtering for "Special permit" but the problem is that the database I'm working on has the date of each permit in the same cell and it's different every time ( example "Special permit: 27/03/2013").
How can I filter just by "Special permit" ??
I need to filter my table by keyword; this is what I did
ActiveSheet.ListObjects("Tabla1").Range.AutoFilter Field:=5, Criteria1:= _
"Special permit"
as you can see I'm filtering for "Special permit" but the problem is that the database I'm working on has the date of each permit in the same cell and it's different every time ( example "Special permit: 27/03/2013").
How can I filter just by "Special permit" ??