+ Reply to Thread
Results 1 to 2 of 2

Macro to copy group of cells and paste multiple times for each row of data

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    USA
    MS-Off Ver
    2011
    Posts
    2

    Macro to copy group of cells and paste multiple times for each row of data

    Hello, I need to copy a group of cells starting from (B2:J2) for each of 8760 rows 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 any help would be greatly appreciated. Please and thank you very much!

  2. #2
    Registered User
    Join Date
    08-09-2016
    Location
    USA
    MS-Off Ver
    2011
    Posts
    2

    Re: Macro to copy group of cells and paste multiple times for each row of data

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy/Paste Multiple times
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2014, 03:56 PM
  2. Macro to copy and paste ranges multiple times
    By MGuru in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 02:16 PM
  3. Using macro to copy group of cells at end of data - repeatedly
    By muadebe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2012, 01:20 PM
  4. [SOLVED] Copy & Paste Multiple Times
    By jkelly228 in forum Excel General
    Replies: 4
    Last Post: 08-10-2012, 03:54 PM
  5. Macro to copy data multiple times
    By TheVril in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-19-2012, 11:31 AM
  6. Replies: 0
    Last Post: 07-10-2006, 04:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1