dlanden
New Member
- Joined
- Aug 9, 2006
- Messages
- 36
Hello everyone. I am trying to figure out a way to consolidate or group some data that I get on a weekly basis. I would like to create a Macro to make this process even quicker each week. Here is a sample of my data.
Column A Column B Column C Column D Column E Column F Column G Column H
1004 RIV 03 03/01/08 CR-R123 COREMART 111.12 0
1004 RIV 03 03/01/08 CR-R123 CENTRAL 123.56 0
1004 RIV 03 03/01/08 CR-R123 APNE 0 56.23
1004 RIV 03 03/02/08 CR-R222 DILLON 189.56
1004 RIV 03 03/02/08 CR-R222 APNE 87.65
1004 RIV 03 03/02/08 CR-R222 KWIK 653.25
What I need to do is group each row that has the same data in column "E" and get a total for column "G" and Column "H". I also need to keep the date that is assinged to column "D" with these corresponding totals. Here is what my data should look like once it is grouped together:
Column D Column E Column G Column H
03/01/08 CR-R123 234.68 0
03/01/08 CR-R123 0 56.23
03/02/08 CR-R222 842.81 0
03/02/08 CR-R222 0 87.65
Any help would be much appreciated.
Thanks,
Dave
Column A Column B Column C Column D Column E Column F Column G Column H
1004 RIV 03 03/01/08 CR-R123 COREMART 111.12 0
1004 RIV 03 03/01/08 CR-R123 CENTRAL 123.56 0
1004 RIV 03 03/01/08 CR-R123 APNE 0 56.23
1004 RIV 03 03/02/08 CR-R222 DILLON 189.56
1004 RIV 03 03/02/08 CR-R222 APNE 87.65
1004 RIV 03 03/02/08 CR-R222 KWIK 653.25
What I need to do is group each row that has the same data in column "E" and get a total for column "G" and Column "H". I also need to keep the date that is assinged to column "D" with these corresponding totals. Here is what my data should look like once it is grouped together:
Column D Column E Column G Column H
03/01/08 CR-R123 234.68 0
03/01/08 CR-R123 0 56.23
03/02/08 CR-R222 842.81 0
03/02/08 CR-R222 0 87.65
Any help would be much appreciated.
Thanks,
Dave