Results 1 to 3 of 3

Thread: Need Macro to extract ALL duplicates/multiples into new sheet

  1. #1

    Need Macro to extract ALL duplicates/multiples into new sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am having a serious dilemma. I am completely confident in deleting and highlighting duplicates in a sheet, however, now, I need to extract rows of duplicates in column B (all multiples, leaving only unique single values in the original sheet) and create a new sheet.

    I need to split the original sheet of over 80,000 rows of information into a sheet with single orders and multiple orders, so that they may be later consolidated.

    I need the duplicates to be from column B. I tried doing a countif earlier (as shown by the million 2's in column C= epic fail) to try and split it into different steps...

    So if,
    Column B
    A
    A
    A
    B
    D
    E
    E

    New sheet would read:
    A
    A
    A
    E
    E

    *Note: of course the entire row would need to be moved, not just the column *

    Please help! This would take me days to do manually. I'm not the most Macro/Excellent proficient, so exact and easy to understand works best!

    Thanks so much!

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    170
    Articles
    0
    Cross-posted, and seemingly solved, here: http://www.mrexcel.com/forum/excel-q...new-sheet.html
    Circumference of a circle = 2πr²



    ²the circle's radius

  3. #3

    Thanks

    Yep, sorry, new to and these forums and I couldn't post a link... Thanks to everyone who helped

Posting Permissions

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