Multiple row population

Hi guys

(You've all been really helpful to me so far).

I have a question and please refer to my attached .xls

I have created a simple userform which populates cells. I have a free text box to update the quantity for each item. I want to know how I would be able to input the quantity and it create that number of rows, not just a figure in cells.

I.E. instead of

A.....B.....C.....D

QE...R.....T.....3



I could have:

A.....B.....C

QE...R.....T
QE...R.....T
QE...R.....T

This can be done much simpler.

I cannot download any attachments where I am right now, could someone
post the code of what I would need for this?



I just want to type in a quantity in the user form and it create that
number of rows.

Please help me

I've managed to download the solution above however that does not seem to work. Can anyone please help with this issue?

Please can someone help me?
I'm sure the code is simple I just can't find it anywhere.

I just want the option of inputting a quantity and it creating multiple rows.

Please help.