Posts by derekfinlinson

    Re: Move Duplicate Rows to New Sheet


    Still having trouble getting it to leave one occurence. Here is an example of the file I'm using. There are more columns but these are the three I need to check on for duplicates. I was also having problems with the range not including the two helper columns which causes an out of range error. Thanks.

    Re: Move Duplicate Rows to New Sheet


    Thanks for the code, it works great. Currently, it's deleting all the duplicatets and I need to keep one of each. I may just need to change some value in the code but don't see anything that would accomplish that. Thanks.

    I have a rather large worksheet of 40000+ rows. I need to find duplicate rows based off of three separate columns. The duplicates then should be moved to a new sheet, and the row deleted in the source sheet. I've got a working macro that just loops through the whole sheet a row at a time but it takes forever, and I'm hoping their is a quicker solution. Any ideas would be greatly appreciated.