Tricky Event Row Insertion - kind of a Loop?

[actjfc]

Excel friends,

I have an Excel Template where I would like to automatically add one row when the user writes text in Cell B10 then the macro will insert one blank row underneath B10. Later, if the user writes something in Cell B11 then the macro will add one empty row underneath B11, and so on up to 10 times. Can somebody help? Thanks!

 

[Rick Rothstein]

I have an Excel Template where I would like to automatically add one row when the user writes text in Cell B10 then the macro will insert one blank row underneath B10. Later, if the user writes something in Cell B11 then the macro will add one empty row underneath B11, and so on up to 10 times. Can somebody help? Thanks!

i presume there is text immediately under the blank cell that is to be filled in, correct? If so, is the user allowed to edit that existing text? For example, let's say you previously filled in B10 so the new row was inserted and B11 is empty. If there is existing data in cells B12 to B19, is the user allowed to edit them or are they locked from being edited?

 

[actjfc]

You are on the issue. The Cell B10 is empty, but the current cell B11 has a noneditable heading/title. So, the idea is inserting rows under B10, so the present B11 is moved further down as the VBA adds new empty rows. Yes, most of the rows under B10 should not be edited by the user (locked). Thanks!