Macro for inserting specific rows with data when there is a change in the column

Hello there!

This is my first post in this forum and I really hope someone can help me with my problem. I am a total newbie when it comes to macros but I sure like using them when it comes to data processing. I have two worksheets "dt_result" and "lookup". I have several columns of data in dt_result and I would need a macro that inserts rows 128:132 from "lookup" (this is the sheet where I store various lookup values and templates) every time there is a change in the value of the cell in column C in the dt_results sheet. I would need the macro to do this until the last used row in dt_result. I know how to insert blank rows but I can't figure this out. Any help would be appreciated.

Julz

Here is a copy of the workbook with the two worksheets I mentioned. A plus would be if the macro would also fill down the generated 5 row gap in columns C and G (in "dt_result") with the value just before the first blank cell. The background to all of this is that unlike all the chemical components, these five field parameters need to be typed in manually. The macro would help me minimize the effort of preparing the table for the manual data input. Thanks.

Wow! It works perfectly! Thanks a bunch. It would be nice to understand all this.