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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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,181,609
Messages
5,930,899
Members
436,765
Latest member
kan01

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