+ Reply to Thread
Results 1 to 6 of 6

Copy block of rows based n times, n being list of items

  1. #1
    Registered User
    Join Date
    08-11-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    58

    Copy block of rows based n times, n being list of items

    Hi There,

    I have two sheets:

    Sheet-1:
    A
    B
    C
    D
    E

    Sheet2:
    ABC
    CDE
    FGH

    Output Sheet should display like the below:

    A ABC
    B ABC
    C ABC
    D ABC
    E ABC

    A CDE
    B CDE
    C CDE
    D CDE
    E CDE

    A FGH
    ........
    E FGH


    I am trying to do but all forums have code which copies n times based on a cell value and it is sorted but I need the entire block after block.

    Kindly request you to help me on this logic.

    Regards,
    Sri

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: Copy block of rows based n times, n being list of items

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    08-11-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: Copy block of rows based n times, n being list of items

    Hi Yasser,

    Thank you for the quick response.
    The code works like magic, I should have been more specific. My sincere apologies.
    I have the below setup, logic is the same and output is exactly working the way it has to.

    Only thing is Sheet-1 has more columns and Sheet-2 data is two columns.
    Sheet-3, all columns in Sheet-1 + Sheet-2 columns.

    Attached is the spreadsheet for your reference. Your support will save loads of time at our end.

    Thanks in advance.

    Kind Regards,
    Sri


    Prob Stat.xlsx

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: Copy block of rows based n times, n being list of items

    Hi Sri
    Try this modification
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-11-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: Copy block of rows based n times, n being list of items

    Hi Yasser,

    Thanks a bunch. The code works beautifully. You just saved lot of time at my end. :-)

    Best Regards,
    Sri

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: Copy block of rows based n times, n being list of items

    You're welcome Sri. Glad I can help
    Please mark the thread as solved

+ 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 rows based on criteria 3 times into a separate worksheet
    By Ganeshgopinath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2015, 09:03 AM
  2. Copy cell block content based on drop-down list value
    By s_lessard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2015, 10:00 PM
  3. [SOLVED] Hide Rows based off items from a ComboBox List.
    By Glitch_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2014, 09:27 AM
  4. Copy several times the same block of cells
    By Torete_1 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-11-2014, 04:41 PM
  5. Replies: 0
    Last Post: 06-06-2013, 02:03 AM
  6. Replies: 0
    Last Post: 05-18-2012, 11:18 PM
  7. Generating a items in a list n times
    By jk1 in forum Excel General
    Replies: 4
    Last Post: 09-09-2011, 06:06 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