Copy set of text values and paste multiple times to another worksheet

  • 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

  • Re: Copy set of text values and paste multiple times to another worksheet


    Hi Marvhielnx,


    Try this:



    Regards,


    Robert

  • Re: Copy set of text values and paste multiple times to another worksheet


    Another way......

    Regards.
    sktneer

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!