+ Reply to Thread
Results 1 to 6 of 6

create duplicate rows for each cell contents

  1. #1
    Registered User
    Join Date
    12-22-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    9

    Post create duplicate rows for each cell contents

    Dear All,

    How to insert each duplicate rows in excel?

    Regards
    MSN-TESTER

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: create duplicate rows for each cell contents

    Could you provide an example?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    12-22-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    9

    Post Re: create duplicate rows for each cell contents

    Issue : I have a list of details in column A in sheet2, From the sheet 2 find the record available in sheet1 and repeat with row if found same record in the delimited values in sheet1.

    Regards
    MSN-Tester
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: create duplicate rows for each cell contents

    You will need to show a few samples of your expected outcome, I do not understand what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    12-22-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: create duplicate rows for each cell contents

    example will always be achieved !

    Step1 : Database list in Sheet1 : Column A
    BA123
    CA546
    DG888

    Step2 : Identify from Sheet2 : Column A
    CA546

    Step 3: Result : if Found record then create in Sheet1 Column A
    CA546
    CA546

    Regards
    MSN-Tester

  6. #6
    Registered User
    Join Date
    03-25-2014
    Location
    united states
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: create duplicate rows for each cell contents

    Hello Everyone!!!
    I just joined the team.
    Does any one know how to create duplicate rows? I have 3 columns on names-email-phone number.
    Some need 5 duplicates, others 10.

    Thanks

+ 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] Create Duplicate Rows
    By ignes in forum Excel General
    Replies: 5
    Last Post: 12-24-2013, 11:20 AM
  2. Clear contents of cell if duplicate
    By johnph in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-23-2013, 08:48 AM
  3. Split cell contents over multiple rows based on cell contents
    By naigy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2011, 05:38 PM
  4. Macro to create duplicate rows
    By Q-D in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2009, 03:40 PM
  5. How to Auto duplicate cell contents?
    By mltong in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 07:00 AM

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