find row that has a value in column and then copy rows by value into new sheet

[muss1210]

Hello Forum

I have an order form (sheet1) columns A:E where the customer will populate a cell in column F with how many items they require.

I would like a macro that would find the row with a value in column F and then copy that data ( columns A:E ) onto sheet2 by the value in column F. and then enter a 1 in column F

Once it has processed a row it would need to carry on to find the next row and repeat and then paste after the last row of data from the previous entry.

For example the below i would like the below 5 times for the 1st row and 2 times for the second row

1234 Apples John London 24th 5
7654 Orange Bob Paris 1st 2


1234 Apples John London 24th 1
1234 Apples John London 24th 1
1234 Apples John London 24th 1
1234 Apples John London 24th 1
7654 Orange Bob Paris 1st 1
7654 Orange Bob Paris 1st 1


Thank you in advance

[Mumps1]

Try:

Please Login or Register  to view this content.

[FlameRetired]

If a VBA solution is not required BMV has an excellent formula approach to these kinds of challenges.

How to Copy Cell Value for x number of times