Consolidate Items of Invoices

Please refer to attached sheet...


I need a macro to generate a sheet where you choose the month
as mm/yyyy ( 09/2010, 10/2010) and it will consolidate the invoice item.


Source sheet would be Inv_Sum in the attached sheet.

Destination sheet would be called as Monthly_Summary and it will list:

ORDER QTY SHIP QTY B/O QTY ITEM# DESCRIPTION PRICE

I would suggest to use Item # in column D of Inv_sum as unique number for consolidating.

Below is the example for some invoice item for 07/2010 ( Refer to Sheet1)

ORDER QTY SHIP QTY B/O QTY ITEM DESCRIPTION PRICE
7 7 0 110599 DQ 1/4 LB GRILLBURGER 38.52
11 11 0 110979 20#-6/1 H MST BEEF PATTY 38.29
3 3 0 234080 DQ SMALL CONE 32.98

Please let me know if you have any further questions about this..

Thank you,

RM

Hi RM

How do you want to handle "SHIP/HANDLING" and "TAX" on the Monthly Summary. Should they be added as line items?

John

Hi RM

I'm looking at it as we speak.

John

Hi RM

Try the attached and let me know of issues.

John

Hi RM

Glad it works for you. A tip of the scales is always appreciated.

John