Filter non-number client names

[Desmond]

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!

[Tom Ogilvy]

Probably easiest to use an adjacent column to put in a formula that will
return a result which is easy to filter on.

=iserror(1*A2)
drag fill down the columrn

Filter on True if you want the non-numbers or False if you want the numbers.

--
Regards,

"Desmond" <[email protected]> wrote in message
news:[email protected]...
> 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!
>