+ Reply to Thread
Results 1 to 4 of 4

Insert and paste 3 rows in every other row of a sheet

  1. #1
    Registered User
    Join Date
    11-05-2020
    Location
    Los Angeles
    MS-Off Ver
    Latest
    Posts
    3

    Insert and paste 3 rows in every other row of a sheet

    I have a sheet with 1000s rows of products data. The problem is each product, since its a variable products, has to have three additional row below it. Now the three additional rows are always the same. So lets say
    OK I think I made an error in the question so

    I have in sheet1
    Product 1 Price Description SKU Image
    Product 2 Price Description SKU Image
    Product 3 Price Description SKU Image
    Product 4 Price Description SKU Image

    Another sheet2
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    I want sheet 3 be like
    Product 1 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    Product 2 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    Product 3 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    Product 4 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}
    ....

    Now I know I have to be able to select every other row in my sheet first insert three blank rows below it and then paste them in there. Or if there is any easier way to do this please let me know.
    Attached Files Attached Files
    Last edited by alexiirj; 11-05-2020 at 06:33 PM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,013

    Re: Insert and paste 3 rows in every other row of a sheet

    assuming as you've shown what you have in the original sheet
    put this in the results sheet in A2 and drag right then down until it returns zero...
    =INDEX(Sheet1!A$2:A$1000,ROUNDUP(ROW(A1)/4,0))
    extend the rows if needed.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    11-05-2020
    Location
    Los Angeles
    MS-Off Ver
    Latest
    Posts
    3

    Re: Insert and paste 3 rows in every other row of a sheet

    I attached a sample file
    OK I think I made an error in the question so

    I have in sheet1
    Product 1 Price Description SKU Image
    Product 2 Price Description SKU Image
    Product 3 Price Description SKU Image
    Product 4 Price Description SKU Image

    Another sheet2
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    I want sheet 3 be like
    Product 1 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    Product 2 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    Product 3 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    Product 4 Price Description SKU Image
    Option size {1,2,3,4,5....}
    Option color {red, rose, black}
    Option last {x, y, z}

    options never change or get incremented in anyway
    Last edited by alexiirj; 11-05-2020 at 06:33 PM.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,208

    Re: Insert and paste 3 rows in every other row of a sheet

    Try the following:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Copy , Insert rows and Paste data from two sheets to third sheet
    By narendra.tanmay in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-01-2020, 09:48 AM
  2. Copy cells with data - paste (insert rows) to next sheet.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2016, 01:28 PM
  3. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  4. Insert rows on sheet as rows on master sheet are filled in
    By mikejennings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 03:01 PM
  5. Copy Sheet / Create & Name New Sheet / Insert Before a Sheet / Paste Data
    By thinkspac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 02:27 PM
  6. [SOLVED] Code to cut and paste rows (insert cut cells) in a protected Excel sheet
    By bob.mc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 04:47 PM
  7. Copy paste data, insert rows, insert data and change . to -
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2010, 01:44 AM

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