Thread: Insert Row using Macro

I'm new to using macro in Excel and wondering if someone can help with this task.

From the attached sample, when a row is inserted in row 6, I want the following to happen;

1. Automatically fill cell C6 with Number-A-04 (increament by 1)
2. Leave cell D6 blank for user to enter text
3. Automatically insert row in row 11 and row 17
4. Automatically fill cell C11 with Number-B-04 and cell C17 with Number-C-05
5. Leave cell D11 and D17 blank for user's texts.

I attached a sample sheet.

Thanks
febad