+ Reply to Thread
Results 1 to 2 of 2

Insert Rows in Worksheet depending on Duplicate Entries in Another Worksheet

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Berlin
    MS-Off Ver
    Excel 2003
    Posts
    39

    Insert Rows in Worksheet depending on Duplicate Entries in Another Worksheet

    Hi,

    I need to Insert Rows in a worksheet (sheet2) depending on the the number of times a value is duplicated in another worksheet(sheet1).

    (Uploaded reference workbook)

    This is what I want the Macro to do :
    -> Count the number of time a value has been duplicated in Sheet 1 Column C .
    -> Insert the number of rows (No. of Duplicate Entries - 1) in Sheet2 below the same value found in Column A Sheet2.
    -> Copy and Paste the data into the newly rows from the original one above (Sheet2).

    PS: The macro could also just 'insert copied cells' below the original row in sheet2 based on the number of times (minus 1) that the same value was duplicated in sheet1.

    NOTE: The values in Sheet1 Column C are the same as Column A Sheet 2.

    I appreciate your help.

    Cheers,
    JN
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-20-2010
    Location
    Berlin
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Insert Rows in Worksheet depending on Duplicate Entries in Another Worksheet

    Posting here_
    http://www.mrexcel.com/forum/showthread.php?p=2491677

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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