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 ?
Bookmarks