Excel 2007 : Macro to sum and merge like cells

I would like to run a macro that will take a set of data and merge like cells in specific columns, add other specific columns, if a number of cells match in a row. Here is my example. I want to have the macro search for rows that have matching "date" fields, matching "product" fields and matching "color" fields...and then have the macro merge those rows in to one row while summing up the "hours open" field and "total sold" field.And then display it chronologically.

I am brand new to the excel/vba world. Below is a visual example. I appreciate any and all help. Thanks.



What it looks like before:

Date total sold product color hours open
12/22/2011 10 1 2 5
12/23/2011 2 2 2 4
12/23/2011 5 2 2 3
12/22/2011 7 1 2 5
12/22/2011 6 2 1 8
12/22/2011 4 1 2 6
12/22/2011 8 1 1 4
12/23/2011 11 2 2 3
12/23/2011 2 1 2 4

What it should look like after :

Date total sold product color hours open
12/22/2011 8 1 1 4
12/22/2011 21 1 2 16
12/22/2011 6 2 1 8
12/23/2011 2 1 2 4
12/23/2011 18 2 2 10

That def helped. Any idea on how I can order the dates chronologically?