Thanks Dale, since that will take sometime to invoke the setting
everytime to do this job.

Do you have any idea to use Macro so that can simplify task.

Thanks again.

Dale Hymel wrote:
*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/
*


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