Delete entire row based on criteria

Morning all,

I have attached an example worksheet. Sheets 1 and 2 show you how my data is now.

To explain, based on the name column ('B') I would like the code to delete the ENTIRE ROW when a person only features on either sheet 1 or 2 (but not both). For example, in the attached the person called 'Dave' would be deleted from Sheet 1 because he only features on Sheet 1 and not Sheet 2.

So if a person is present on both sheets then they are left alone. The spelling of each name will always be correct but the list of names may be in different orders (as they are in sheet 1 and 2 in the example).

Thanks

Try it. Now rows are highlighted. If everything is correct, delete this line

Please Login or Register  to view this content.

and uncomment this line

Please Login or Register  to view this content.