use Data=Filter = Autofilter

You can use a custom format on the first column.

turn on the macro recorder while you do it manually and this should give you
the basic code you need.

--
Regards,
Tom Ogilvy

"Andri" wrote in message
...
Hi,
I have a purchase data, where the fields are Date PO, PO#, Supplier, Qty,
Up, Total Price.

excerption the data as follow:
ColA Col B Col C
Date Supplier Total Price
01Jan A 100
13Jan A 50
30Jan B 75
02Feb A 25
13Feb B 100
26FEb B 50

how to list the purchase ONLY for month Jan?
by VBA Code?

Thank you for the help.

Andri