Code to copy rows downwards based on 'X"

[janfin2]

Example.xlsx

Hi Gurus,

I need some help with a macro that will copy data from specific columns in one row and paste it in the row below "x" number of times; the "x" is a value defined by the user. I've attached a file with an example of the raw data and how I want to it to look below that.

Basically stated: Copy cells A7:C7 and E7 down a total of "x" times where "x" is always changing.

Can anyone shed some light on this or point me in the right direction?

Thanks!
Jason

[JBeaucaire]

DUPLICATE ROWS

Here's a macro designed to take any data set with any number of rows and columns and expand the dataset using the number found in the last column. There is a sample file there to see it demonstrated, too.

Duplicate Rows

You could use the macro asis by simply moving your QTY column so that it is the last column, then run it, then move it back.