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

summary by date
 

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/

summary by date
 

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/

summary by date
 

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :-)
----------------------------------------------------------------------------



"BULEMOON" wrote in message
...
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/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 23/12/2003