Help with partially working Macro to separate groups

Hello,

I wrote a Macro, however it does not work all the time. I have put in two sheets. The first works the second doesn't. I can't seem to figure out what is wrong as everything appears to be correct.

I think you want iRow = 2, otherwise you start by comparing E6 to E5, which explains why nothing is happening on your second sheet.

You need to loop back ward if you want to inset rows. Avoid using do and while loops, use instead for loop, like

Please Login or Register  to view this content.