excel. find and remove help....

[Paul11]

is there a way that excel can look through one spreadsheet and find and remove things from another

to explain. i have a spreadsheet of email addresses (spreadsheet 1), and another spreadsheet of email address (spreadsheet 2) that i want to remove from the first spreadsheet

at the moment, i am going through one by one, is there a way to tell exel to find all the email address from spreadsheet 2 and remove them from spreadsheet 1 ?

thank you

 

[Paul11]

not really sure i know what im doing , but ill give that a go

thanks

 

[Paul11]

yes, i want to remove the emails on spreadsheet 1 ( that are listed on spreadsheet 2)

thank you for all your replies, i will have a look at all the options tomorrow. ..

 

[Paul11]

didnt get a chance to do it yet, sorry, had a hectic weekend.

i will try the suggestions in this thread a bit later...

thanks