Insert constant number of rows, based on cell value

[Tony_Luis]

Hi all,

I'm trying to figure out a way to insert 4 rows, based on the value cells in a specific 1-column range.

For example, for all cells in column C which equal "I need help", insert 4 rows below.

Any help would be much appreciated.

Thanks!!!
Tony

 

[Tony_Luis]

Thanks all! My problem has been solved. This forum is awesome!

 

[igold]

Hi Tony,

Thanks for the feedback and the LIKE. I am glad that we all could help you.

igold