I am stuck trying to figure out how to delete duplicates based off of rejection date. My goal is to delete rod serial number repeats if and only if the rejection date is within 24 hours of each other and to save the first rejection of the duplicates.

For example if rod "123" gets reject at 10:00am and at 10:10am on Monday then it would delete the 10:10am entry. If rod "234" get rejected at 10:00am on Wednesday and 2:30 on Friday it would not delete either of them.

I have been trying to do this using VBA but I am new and struggling. I hope this is descriptive enough!

Thanks

DeletingDuplicates.PNG