fitler by keyword

[christchaaya]

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" ??

[mdmackillop]

ActiveSheet.ListObjects("Tabla1").Range.AutoFilter Field:=5, Criteria1:= _
"Special permit*"

Add an asterisk as a wildcard

[christchaaya]

Thank you a lot. You've been very helpful.

Regards