Excel VBA for formatting a data dump

[lorber123]

I get a data dump every month that I need to have formatted and summarized. If you look at the Source Data tab, you will see that each Name is listed multiple times. Some of the names are listed twice on the same day. I need to consolidate same day rows into one row that totals the hours and amount columns.

An example of this is Aquino, Silvio. He has two entries on 4/3/2015. We would add the hours and the amount for these and make it one row. The final product is seen on the Converted Sample Tab.

Can someone help me create the VBA code to consolidate same date rows into one and then have the table formatted simliar to the Converted Sample.

[hectop]

This macro should do it. I didn't put in the row formatting.
If you want to have it sorted by ID, it requires some additional work on sorting and checking for names
Example v2.xlsm