If text encountered, add rows [Closed]

Report
-
Hello,

I would appreciate any help on a worksheet of thousands of lines of data I get and must format every week. Whenever the text "-C0" is encountered anywhere in the text in row C, I need to add 7 rows below it.

Thanks in advance!


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!