I need to prepare data to create a PivotTable, and have filtered two columns,

Workbooks("2005q4").Worksheets("Master").Rows("2:" & Rows.Count).AutoFilter
Field:=2, Criteria1:=">=07/01/2006", Operator:=xlAnd,
Criteria2:="<=07/31/2006"

Workbooks("2005q4").Worksheets("Master").Rows("2:" & Rows.Count).AutoFilter
Field:=4, Criteria1:="<>Query", Operator:=xlAnd, Criteria2:="<>Gratuity"

Now i need to filter the client name which are numbers, they look like:

786
AAA
BBB
65
CCC
5677
DDD
EEE
.......

Any suggestions, thank you in advance!