Macro deleting all, not just the duplicates

[JamesT1]

Good afternoon all

I have a workbook with several sheet... two of which are called 'Data' and 'Add Driver', both have headers.

I'm looking at comparing the information in column B in both sheets,,, when it finds a duplicate I'm looking at deleting the row in the sheet 'Add Driver', the ranges, including headers, start in Row 8 on the 'Data sheet and Row 1 on the 'Add Driver Sheet'

I have been working with this macro but the closest I can get it, is for it to delete everything, except the headers in the 'Add Driver' sheet

Any help would be much appreciated

Many thanks

JT

Please Login or Register  to view this content.

[JLGWhiz]

Please Login or Register  to view this content.

This statement says if you don't find a duplicate, then delete the row. I think if you change the (=) symbol to a (>) symbol it will do what you want.

[JamesT1]

JLGWhiz

Now it works a treat,, many thanks for your help

Much apprececiated

JT

[JLGWhiz]

JLGWhiz

Now it works a treat,, many thanks for your help

Much apprececiated

JT

You're welcome,
regards, JLG