Copy duplicates and paste in new worksheet

[ellac]

Hi everyone

I want a procedure that will check my sheet and automatically copy all duplicates and paste them into another sheet in the same workbook.

Thanks in Advance

Ell.

 

[erik.van.geit]

Hello, ellac,

This is an ever-returning-question with lots of variations.
Click "search" on top of your screen, type "duplicate(s)" and a lot of examples will come to you!

kind regards,
Erik

 

[ellac]

I have checked the duplicates code, but I have not found one that strictly copies to a new sheet without putting any entries in the existing sheet.

I hope you understand my explanation.

Thanks.

Ell.

 

[ellac]

I made a mistake, what I need to do is the following:

compare all worksheets in a workbook and copy and duplicates to another worksheet in the same workbook.

I will then password protect the worksheet that has the duplicate copies on it.

Sorry for the confusion, thanks for all the help.

 

[erik.van.geit]

My time is limited but I'll help you with the steps. You can find "how to" here on the Board.

1. copy all data to another sheet in the first column
(all next operations on the new sheet)
2. select all data
3. menu DATA / Filter / Advanced filter ==> unique
4. copy
5. paste to the second column
6. delete the first column

(even manually it's done in relatively short time)

kind regards,
Erik

 

[Von Pookie]

Please see:
http://www.mrexcel.com/board2/viewtopic.php?t=126944