Need Macro to extract ALL duplicates/multiples into new sheet

ashleynsloan

New member
Joined
Dec 4, 2013
Messages
2
Reaction score
0
Points
0
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!
 

ashleynsloan

New member
Joined
Dec 4, 2013
Messages
2
Reaction score
0
Points
0
Thanks

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