OK, what I'm trying to do is this:

I have a spreadsheet where the accounts come in twice on occasion. What I need to do is run a macro to find the duplicate account numbers and pull all the duplicated rows (both orginal and duplicate) into a new sheet.

Ideally, I would like the macro to then later, after applying my normal conditioning to the remaining accounts, pull all of those duplicates back to the orginal sheet and put them after the last account on that sheet.

I would love you long time if you can figure this out for me. Thanks!!!!