Need Macro to extract ALL duplicates/multiples into new sheet

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 single orders and multiple orders, so that they may be later consolidated.

http://www.excelforum.com/attachment...s-1st-part.gif

This is a brief sample of the sheet. 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

Try this on a copy of the data

=COUNTIF(B:B,B2) in C2 and copy down. Wait for calcuation to complete. (is calculation set to automatic in formula ribbon?)

Filter to select rows in column C with value of 1

Delete visible rows

Clear filter.