Auto insert rows?

Hi there -
Is there a way to automatically insert 2 rows after the text in column B changes?


B
Group 1
Group 1
Group 1
Group 1
Group 2 <--Auto insert 2 rows here
Group 2
Group 3 <--Auto insert 2 rows here
Group 3
Group 3
Group 3

Thanks!
Jill

Hi Jill,

Follwing code should help

Please Login or Register  to view this content.

HTH
Carim