VBA Code to list vendors

[Andri]

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

[Tom Ogilvy]

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