Insert A Row After Each Criteria Change
Posted by Brian on August 13, 2001 1:25 PM
I have a sheet that has a list of months in column A and then other data in following columns. I would like to do the following using a macro:
1) Insert a new "total" row after each month
2) Then sum each column in this new row.
My data looks something like:
Month: Value
05 1
05 3
05 5
06 1
06 2
06 2
07 3
07 3
07 3
And with the macro do this:
Month: Value
05 1
05 3
05 5
Sum 9
06 1
06 2
06 2
Sum 5
07 3
07 3
07 3
Sum 9
I'm not exactly sure how to write the vb to add the new row and then do the sum at the end of each group.
Thanks,
Brian