Try a PivotTable, they are excellent for summarizing data


"BULEMOON" wrote in message
...
I have large no. records generate by daily operation about 3000/month. I
have to summarize by customer and partno. and also orginized in
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.
Simon


---
Message posted from http://www.ExcelForum.com/