Help Matching Duplicates

Hi all.

Could anyone please help matching duplicates using VBA if this is possible

I have already posted on Mr Excel forums but have had no response
https://www.mrexcel.com/board/thread...cates.1254238/

We scan codes against lots we have entered in columns D & E. We then get a master sheet sent which may contain extra lots we have not scanned or we may have scanned extra lots which are not on the sheet.
In the example below you can see all match apart from lot 4 which was not scanned
1708416823613.png

I want to add a line on columns D & E and add the corresponding number in.
Lot 6 which was scanned is not on the master sheet so D & E will need deleting
1708416852033.png

This is the final outcome I require.
1708416894943.png

Thanks for looking.

Regards,

Graham

Hi again.

Please see sample doc


Regards,

Graham

Thanks a lot for this.
It works perfectly

Regards,

Graham