Hi,

I have a report that I will need to insert a blank row after each unique group of value, then sum the above value. Is there a way to do it in VBA?
The data is already sorted by same value in column P.
From range P15, go to last same value, then insert 2 blank row, then on range S to U, sum the total above.
Then continu.

Here is the spreadsheet Sheet1(original), Result (result that should be).

Split Sum Question.xlsx

If anyone can help on this. Thank ou.