Automatically create and fill rows based on a given quantity

Hi all,

I'm struggling with creating a macro which has to fill lines automatically, based on a certain qty.
Attached file has sample data in it.
The tab "outbound" starts on row 8 with the headers and in row 9 and below the data (partnumber, description, quantity etc).
The tab "collection_1" has the data filled in already by myself as the desired result, but I need a macro to do that for me.

so a row with a quantity 5 (column H on tab "outbound") need to be shown as 5 similar rows on tab "collection_1" (only difference is that column H on this tab will be 1 by default).
Below these 5 rows, it should then produce 20 similar rows with for the 2nd row on the "outbound" tab, then 10 rows for the 3rd row etc..
Number of rows in the "outbound" tab can vary, is not a fixed number of rows, so that should be taken into account when writing the VBA code.

Hopefully this is making some sense to you ;-)

I sincerely hope you can help me with the above!!

Thanks in advance,
PeterExample file.xlsx

I think it will solve your problebExample file.xlsm

Maybe:

Please Login or Register  to view this content.

Hi Piyushanand,

This works perfectly! Thanks a million!

Regards,
Peter