Macro to Sum Data in Multiple Columns based off Date in Column A

I'm trying to write a macro that will sum the data contained in columns B through E based on the date in column A (please see attachment). In other words, I'd like to create a new table with one row per date on a new sheet that contains the sum of the data in column B, C, D, E on 8/7/13, 8/8/13, etc. The problem I am running into is that the number of rows containing data will vary from date to date. I'm relatively new to writing macros but this doesn't seem like it should be too terribly difficult. Any help or tips would be greatly appreciated!

Hey,

Here.
It is fairly un-elegant.
Just a bunch of arrays and loops.
There is probably better ways of doing it.

Please Login or Register  to view this content.