J
joecrabtree
All,
I am looking for a way to summarize data. The data format I have is as
follows (Although there could be more of it):
DATE CODE QUANTITY VALUE
01/01/09 ABC 10 1000
01/01/09 ABC 1 100
01/01/09 KDK 4 44
02/01/09 JDJ 2 13
02/01/09 JDJ 33 22
This data is in a worksheet called 'data'. I would like to summarize
this data as follows in a sheet called 'output':
DATE CODE QUANTITY VALUE
01/01/09 ABC 11 1100
01/01/09 KDK 4 44
02/01/09 JDJ 35 35
I.e. summarized by date and code,
Ive tried using pivot tables, but I would like to automate this using
VBA.
Any ideas?
Thanks
Joe
I am looking for a way to summarize data. The data format I have is as
follows (Although there could be more of it):
DATE CODE QUANTITY VALUE
01/01/09 ABC 10 1000
01/01/09 ABC 1 100
01/01/09 KDK 4 44
02/01/09 JDJ 2 13
02/01/09 JDJ 33 22
This data is in a worksheet called 'data'. I would like to summarize
this data as follows in a sheet called 'output':
DATE CODE QUANTITY VALUE
01/01/09 ABC 11 1100
01/01/09 KDK 4 44
02/01/09 JDJ 35 35
I.e. summarized by date and code,
Ive tried using pivot tables, but I would like to automate this using
VBA.
Any ideas?
Thanks
Joe