Hopefully someone can help me with this:

I have a table of data with the rows sorted by date. There are multiple entries with the same date, and I need to add the contents of each row with the same date, preferably into another table so I don't lose any of the original data.

I can't find any VBA function that would do this. Can anyone help me out with the code?

Thanks
Greg