Copy duplicates and paste in new worksheet

Status
Not open for further replies.

ellac

New Member
Joined
Oct 4, 2004
Messages
37
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.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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

New Member
Joined
Oct 4, 2004
Messages
37
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

New Member
Joined
Oct 4, 2004
Messages
37
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

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 
Status
Not open for further replies.

Forum statistics

Threads
1,147,507
Messages
5,741,566
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top