Maybe using excel's built in Data|Subtotals would be sufficient.

In fact, you'd be able to get subtotals for each of your columns.

ConfusedNHouston wrote:

In looking at column A in a spreadsheet, I have successive groups of like
entries. For instance cells A2 through A6 might all pertain to a given
product, with the data in columns B through E defining that product. Cell A7
through A11 might pertain to another product; A12 through A15 to another, etc.

I'd like to separate the products by inserting one or two (possibly more)
blank lines. How would I do this? Is there a way to use the "IF" statement,
IF(A7 is not equal to A6, then insert lines in rows 7 and 8). Or is there a
way to write a macro that will validate one cell's content relative to
another? A macro that would spot an inequality in cell contents (text) and
use the occurance of inequality as the insertion point for a blank row?

--

Dave Peterson