Macro to SUM and COUNT rows that have been seperated by an Item.

[bkanealy]

All I have a worksheet that I have to separate the data by date. I have that much figured out how to insert two lines after each change in date.

What I'm needing is at the column to the right of the Amount a summation of the days $$$$ and in the next column a count of transactions. I'm an extreme newby to VBA. Thanks you for your help!

I've attached a worksheet giving the layout.

[PCI]

Is the original data with empty rows prepared or do we need to do it?

[AB33]

First post after 10 years. This could be a record.
All in one, including inserting rows. The code works on the active sheet.

[PCI]

See attached a possibility

[bkanealy]

Okay, I'm having an ID10T moment. The macro works great for dates in column "A". For a date field in column "I", would the code change from:

For i = .Cells(.Rows.Count, 1).End(xlUp).Row + 1 To 3 Step -1

to

For i = .Cells(.Rows.Count, 9).End(xlUp).Row + 1 To 3 Step -1

[AB33]

Please Login or Register  to view this content.

[bkanealy]

AB33,

Thanks so very much.

Brian