Macro shows duplicated entries but sometimes they are not duplicated due to data.

I was given this macro to delete matching records from sheets 1 & 2. It seems to work good but the issue I seem to be having is when there is 2 entries exactly the same in sheets 1 and 2 its coming up pointing out that its a duplicate entry. This is supposed to be the case but when there is 1 entry in sheet 1 and then 2 entries in sheet 2 the same then this is a duplicated entry and needs marking up as duplicate.

Can this macro be amended to do that?

Please Login or Register  to view this content.

Hi,
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Indicate with a few examples which records you would want deleted

I can't help thinking there is a much simpler macro which can avoid looping code and use standard Excel MATCH functions to identify duplicates then delete them



To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Right here is one example of what I have.

On sheet 1 it shows data 1025 5698 23/05/2019 £10.00 twice and also twice on sheet 2. When I run the macro at present it shows it as a duplicate on sheet 2 but it is not a duplicate as there are 2 entries on sheet 1 and 2..
This will need deleting as per macro.

On sheet 2 it shows data 2568 5666 26/02/2020 £12.00 twice but only once on sheet 1. This is a DUPLICATE and need it marking as dup