I have an excel 2010 spreadsheet and am looking for some help for a requirement as follows:

I have a date column followed by a currency column (data types).

When I enter something in both columns, I need to identify all rows having the same date and in another cell write the sum of all the currency columns.

For example,

A1 = 12/20/2012
B1 = 250.00

A2 = 12/21/2012
B2 = 45.10

A3 = 12/20/2012
B3 = 10.00

D1 = 12/20/2012
E1 = 260.00


I am not new to VBA so i'm aware that I can achieve this in VBA.

My question: is there a built in way of doing this ?