Duplicate line x times

[Sniper]

Good Day

I have an excel sheet that has 5 columns:

A1 = ID
A2 = Item
A3 = Description
A4 = Quantity
A5 = Price

I am trying to write a macro to add X amount of lines to new sheet depending on the Quantity value.

IE. if the Quantity is 5 it should have 5 of that line moved to the next page etc

the QTY will not pull through to the next page for it's now only 1

[Mumps1]

Hi Sniper. Did you mean A1,B1,C1,D1,E1 instead of A1 to A5?

[Sniper]

Sorry Yes, A1 - E1

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

In this case Sheet3 is the destination Sheet.

[Mumps1]

Hi Sniper. Assuming you have more than one quantity going down column D, do you want to copy each row 5 times to another sheet based on each quantity or do you want to choose only one row?

[Sniper]

Hi

Just had a look at your code and it seems to do exactly what I wanted it to!!! Thanks John..

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.