delete cells from one workbook to another
 

I have a master list of email addresses for my company, then also have a list
of email addresses that are no longer valid. How can I merge the two to come
up with one list of valid email addresses without having to go through
individually and remove them?

delete cells from one workbook to another
 

Take a look he

http://www.mcgimpsey.com/excel/scrublist.xhtml

In article ,
Lwerner wrote:

I have a master list of email addresses for my company, then also have a list
of email addresses that are no longer valid. How can I merge the two to come
up with one list of valid email addresses without having to go through
individually and remove them?