VBA Code to list vendors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top