Delete Row Macro

[trevor2524]

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?

[ranman256]

You cant go down the row because when you delete a row, your count is off, (Row 3 gets deleted, moves row 4 to 3, then the counter moves to 4, skiping old 4.)
You must go from the bottom up.

for r = activecell.row to 2 step -1

next