Consulting

Results 1 to 2 of 2

Thread: Macro of copy and paste loop

  1. #1

    Macro of copy and paste loop

    Hello, I need to copy each row of data for 8760 rows starting from (B2:J2) and paste it 4 times each onto another sheet. A1:J1 is already filled and so is A1:A8761 on the new sheet. This is an example of what I want the outcome to look like:

    Sample
    ColA ColB ColC
    TextA TextA1 TextA2
    TextB TextB1 TextB2
    TextC TextC1 TextC2

    Results (for example 3 times)
    ColA ColB ColC
    TextA TextA1 TextA2
    TextA TextA1 TextA2
    TextA TextA1 TextA2
    TextB TextB1 TextB2
    TextB TextB1 TextB2
    TextB TextB1 TextB2
    TextC TextC1 TextC2
    TextC TextC1 TextC2
    TextC TextC1 TextC2

    I have practically 0 knowledge of macros so help would be greatly appreciated. Please and thank you very much!
    Last edited by muddakinjaz; 08-09-2016 at 12:51 AM.

  2. #2
    Can someone please help me I don't even know where to start

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •