summary by date

[BULEMOON]

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

 

[Dale Hymel]

Try a PivotTable, they are excellent for summarizing data

 

[BULEMOON]

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.

 

[Ken Wright]

since that will take sometime to invoke the setting

Not at all. Simply set up the Pivot reports as you want them to appear, and
then use a dynamic range to determine the data each time, eg:-

http://www.contextures.com/xlPivot01.html

Now every time you delete your old data and paste in your new data, simply
refresh the pivot reports you already have set up.