| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to list vendors
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Code to list vendors
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I do a cost comparison of products from many vendors? | New Users to Excel | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| load one vendors prices to a master workbook | Excel Worksheet Functions | |||
| monthly/yearly expence by vendors | New Users to Excel | |||
| Multiple vendors and scenarios - Excel | Excel Worksheet Functions | |||
Linear Mode
