Quote Originally Posted by austenr
Ok let me give this a shot. Starting at row 4 which is the first row of your first customer, you want a blank row inserted after these rows 13, 23, 28, 36,40 and 43. Row 43 would be a blank row immediatly under the last row of data for customer 1.

Then beginning at row 44, (the first row of data for customer 2), count 9 rows and insert a blank row, 10 more rows and insert a row, 5 rows and insert a row, 8 rows and insert a blank row, 4 rows then a blank row and three rows and insert a blank row.

The cycle then repeats for the third customer?

Is that even close to being what you are after?

And the obvious question (well maybe not, what will the blank row be used for?) If its for totaling then there is a far easier way to do what you want.
Yes, I know. I will try to clarify a bit.
To answer you obvious question, yes I am inserting the new rows so I could do the subtotals. (I need the totals for the products for each of the businesses.)

I tried to use the subtotal function and applies to the entire sheet, but the total rows are showing up at the wrong places.

I have attached an excel file, I want subtotals after the last product of each business.

Thanks in advance.