Adding Multiple Rows Based On a Drop Down List

Hello,

I would like to add multiple rows based on the value (1,2,3, etc) that the user selects in a drop down list. I would like the rows to appear below the row in which the number was selected. I need to do this for an entire column, but cannot seem to figure out how to do this. I want to make sure that the cells that have the drop down menus maintain their integrity as well. Please let me know if you can help.

Thanks,
Terra

Hi

Can you create a workbook with what you have and what you need ?

Regards