Deleting cell data in worksheet A if it exists in worksheets B, how?

Probably easy for you guys.. but would love some help. I have a huge list of email addresses in worksheet A but need to remove unsubscribers from this list which all reside in worksheet B. In cell data is in email address form. How do i do this via excel?

you could avoid programming altogether and just do a countif formula. If the email address exists in sheet B then it will return a 1. You can then sort by all the 1's and delete?

Unless you need a button to click to do this job?

Is it possible to post file with dummy data which is in the same format.

Originally Posted by johncassell

you could avoid programming altogether and just do a countif formula. If the email address exists in sheet B then it will return a 1. You can then sort by all the 1's and delete?

Unless you need a button to click to do this job?

Thanks! Could you let me know what this countif formula would look like and I can replace the variables in the formula?

Cant seem to attach it on here.. but it looks something like this:
email addresses from sheet B needs to be removed from sheet A and other row details (eg. name and surname) to those corresponding email addresses should also be removed with the email addresses.

SheetA:
Name Surname username email address
John Smith Smithers [email protected]
Pete Tong Tongers [email protected]
Sarah Meyer Smayo [email protected]
Ken Costa Coffee [email protected]

SheetB:
[email protected]
[email protected]

Pl see attached file .Assumed Sheet B Has got heading.Pl feel free to clarify

Run the macro in worksheet.

Hey, not sure how you did it, how can I replicate what you did with my real data?

Really I could not follow what you want.Pl explain fully.
The rows containing the unwanted Email address are deleted. You want only erase data?
Be clear.Sorry for the trouble.
Thanks.

Hi, sorry, what I mean is .. how do I copy the macro you created to my worksheet with the actual data? Currently you worked on a dummy data sheet. Makes more sense?

Pl copy only macro to your work book.Name the sheet containing email address as SheetB and other sheet as SheetA.Then run macro.If you want to run macro with different names pl inform I will change code so that you can enter the existing sheet names.
Regards

Many thanks for your kind help!