I need help creating a Macro that will Delete the bottom Row it doesn't match in Columns J and P. I have over 15k files that I will need to narrow down and delete duplicates. I need the macro to start in row 1 and Check Columns J and P and see if the match Columns J and P from row 2. If they do it Deletes row 2 and then tries Row 3. If row 3 does not match then row 3 become the new row to be checked it it continues all the way down the sheet until there are no more values found in Column J. Any Ideas?