Conditional Inserting lines

Good morning all
I've got a file that each time the value in column C changes, a subtotal amount is entered in column F, H and I. I've got two lines at the top of the worksheet that I want to insert every time there is a value in column C that contains the word (or part of the word) "Total" (entered automatically when using subtotals), or anytime there is a blank value in any column other than C, F, H or I.

Any ideas?

You will need to use VB to accomplish any line insertion.

Your best bet is to put summary data on a seperate tab and leave the background data on its own sheet.