how to insert row based on the value from cells

[alexandru barabas]

Hi

How can i insert the number of rows under each cell that contains the number of rows to be added?

for example

in C3 i selected number 4 so it will insert 3 rows under that cell, and if possible the row inserted have unable possibility to enter datas only in column J K L M.

in case after some time i will change the value from c3 with 2 than will delete the last 2 rows.

this condition id like to have it at all cels from colomn C
If the cell is emty it wont do nothing, same in case is selected nr1.
i won't have other number only 1 2 3 4 5
if possible to make the inserted rows to look like the pictures attached.
the seet it's protected

Thank you

 

[Nebu]

Hi:

Here is something that can get you started

The following macro will insert rows as per the numbers entered on column C and will protect the columns J K L M from entering any values. But I am not sure about deleting the rows, there should be some identifier to determine which rows have to be deleted.

Thanks