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