I have been looking for a code that will copy set of text values and paste it to another worksheet (existing sheet) multiple times. The number of times it will paste the copied values will depend on the value from another worksheet (specific cell).
Example
Sheet1 (from A2)
Curlysue
Cora
Emz
Mhean
Minda
Beng
Banana
Maria
Sheet2 (A2)
16
Sheet3 (from A2 down)
Curlysue
Cora
Emz
Mhean
Minda
Beng
Banana
Maria
Curlysue
Cora
Emz
Mhean
Minda
Beng
Banana
Maria
Curlysue
Cora
Emz
Mhean
Minda
Beng
Banana
Maria.... (paste 16 times)
Will appreciate any help... Thanks in advance
Marvhielnx