I am using a macro to copy rows from one sheet to another, but I want more than that.
On the sheet "PROGRAMA COBRE" is the No. Spools is greater than 1, I want you to write that line (ID, No. Spools = 1 and Packing Unit) that number of times.

example:

On the second line have:

ID Nº Spools Packing Unit
B0007X02480CU-S 10 120000

I want you to write this line 10 times, where the number of spools happens to 1 in all of them:


ID Nº Spools Packing Unit
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000
B0007X02480CU-S 1 120000


Please find attached my file so they can see what I've done.

http://speedy.sh/swzPR/test1.xlsx


Thanks