Duplicates Macro Modify

[rvesterby]

I searched and found this macro posted in a thread on here. I want to modify it to check only "C" column for dulicates within "C" column and when found show both rows that it found as duplicates and ask if I want to "Remove Duplicate" or "Move To Dup Sheet". If "Remove" button is checked one of the rows is deleted and moved to another sheet named "Duplicate Removed". If "Move To Dup Sheet" button is checked both rows are moved to a sheet called "Duplicate Pair".

The following macro generates a new sheet for each moved entry, I want all the moved rows/entries on the same respectiive sheet. It also checks colum E which I dont need to function.

Verbal example: A spreadsheet with 15000 rows of data, column A to E (5) - Column C is the serial number - Looking for duplicates in column c, but want to see the 2 rows the macro finds, so as to view the other column data before making the button choice of "remove" or "move"

Thank You

Please Login or Register  to view this content.

[Leith Ross]

Hello rvesterby,

Welcome to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.
3. You can also do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.