Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summary by date
I have large no. records generate by daily operation about 3000/month.
have to summarize by customer and partno. and also orginized i monthorder, could anyone have hints to help marco coding ?? 1. input data Customer, Partno. , Qty , unit price, Date a , CD, 5, 20, 10/Jan/03 a , DVD, 2, 30, 12/Feb/03 b , CD, 3, 25, 15/Feb/03 b , DVD, 1, 35, 16/Feb/03 a , CD, 2, 21, 17/Feb/03 2. Customer, partno. , Date , Price, Date, Price, Jan/03, Feb/03 a , CD, 5 , 20 , 2 , 21, a , DVD , 2, 30, 0 , 0, b , CD , 3 , 25 , 0, 0, b , DVD , 0 , 0 , 1, 35, Thanks and appreciate for any of suggestion. Simo -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal by Date and Summary in Lists? | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Summary of values from a date range | Excel Worksheet Functions | |||
Summary Help | Excel Programming |