Hello,
Could you please help creating a macro that sum up amount on Column C, then list the result on Column D, if the date on Column B is same?
Below is part of a very long worksheet that I manually sum up and highlighted based on same date on Column B. Thank you for your HELP!
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 278"]
[TD="class: xl63, width: 64"]Alpha[/TD]
[TD="class: xl64, width: 179"]19-02-25[/TD]
[TD="class: xl65, width: 64"] 12.99[/TD]
[TD="class: xl66, width: 64"] [/TD]
[TD="class: xl63"]Alpha[/TD]
[TD="class: xl64"]19-02-25[/TD]
[TD="class: xl65"] 7.99[/TD]
[TD="class: xl66"] 20.98[/TD]
Alpha
[/td]
[TD="class: xl67"]19-03-03[/TD]
[TD="class: xl68"] 15.99[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl63"]Alpha[/TD]
[TD="class: xl64"]19-03-09[/TD]
[TD="class: xl65"] 3.44[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl63"]Alpha[/TD]
[TD="class: xl64"]19-03-09[/TD]
[TD="class: xl65"] 4.99[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl63"]Alpha[/TD]
[TD="class: xl64"]19-03-09[/TD]
[TD="class: xl65"] 14.99[/TD]
[TD="class: xl66"] 23.42[/TD]
Alpha
[/td]
[TD="class: xl67"]19-03-13[/TD]
[TD="class: xl68"] 7.99[/TD]
[TD="class: xl69"] [/TD]
Alpha
[/td]
[TD="class: xl67"]19-03-14[/TD]
[TD="class: xl68"] 18.99[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl63"]Alpha[/TD]
[TD="class: xl64"]19-03-25[/TD]
[TD="class: xl65"] 22.00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl63"]Alpha[/TD]
[TD="class: xl64"]19-03-25[/TD]
[TD="class: xl65"] 19.99[/TD]
[TD="class: xl66"] 41.99[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
Michael
[/td]
[TD="class: xl67"]19-02-22[/TD]
[TD="class: xl68"] 94.38[/TD]
[TD="class: xl69"] [/TD]
Michael
[/td]
[TD="class: xl67"]19-02-23[/TD]
[TD="class: xl68"] 10.00[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-02-24[/TD]
[TD="class: xl72"] 7.99[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-02-24[/TD]
[TD="class: xl72"] 9.99[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-02-24[/TD]
[TD="class: xl72"] 16.99[/TD]
[TD="class: xl72"] 34.97[/TD]
Michael
[/td]
[TD="class: xl67"]19-02-25[/TD]
[TD="class: xl68"] 31.95[/TD]
[TD="class: xl69"] [/TD]
Michael
[/td]
[TD="class: xl67"]19-02-27[/TD]
[TD="class: xl68"] 26.60[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl63"]Michael[/TD]
[TD="class: xl64"]19-02-28[/TD]
[TD="class: xl65"] 17.95[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl63"]Michael[/TD]
[TD="class: xl64"]19-02-28[/TD]
[TD="class: xl65"] 27.95[/TD]
[TD="class: xl65"] 45.90[/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-03-01[/TD]
[TD="class: xl72"] 20.00[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-03-01[/TD]
[TD="class: xl72"] 8.60[/TD]
[TD="class: xl72"] 28.60[/TD]
Michael
[/td]
[TD="class: xl67"]19-03-02[/TD]
[TD="class: xl68"] 12.99[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-03-03[/TD]
[TD="class: xl72"] 13.55[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-03-03[/TD]
[TD="class: xl72"] 9.55[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl70"]Michael[/TD]
[TD="class: xl71"]19-03-03[/TD]
[TD="class: xl72"] 3.99[/TD]
[TD="class: xl72"] 27.09[/TD]
Michael
[/td]
[TD="class: xl67"]19-03-04[/TD]
[TD="class: xl68"] 12.99[/TD]
[TD="class: xl69"] [/TD]
Michael
[/td]
[TD="class: xl67"]19-03-05[/TD]
[TD="class: xl68"] 15.99[/TD]
[TD="class: xl69"] [/TD]
[/TABLE]