VBA code for sorting duplicates and calculations

[86gts]

Good day guys, i have an issue, i have been trying to work out a code which will remove duplicates from col a and perform calcualtions also.

i.e

Coloumn A contains dates of the month 110502 so 2/5/11,
110502 12.07
110504 1
110504 4
110506 9

the other coloumn contains a number which need to add up so the final display will be
110502 12.07
110504 5
110506 9

i have tried remove duplicates and toyed with a few other options to no avail.

[86gts]

bump, anyone?