Write a formula in Book1 that finds missing in book2

=ISNUMBER(MATCH(G1,'[Book2.xls]June 08'!$A:$A,0))

Then filter on that formula column looking for TRUE, and delete all visible
rows.


--
__________________________________
HTH

Bob

"GezCam" wrote in message
...
I have one workbook which lists email addresses. Book 1

I have another workbook which lists the email addresses from Book 1 which
are bad. Book 2

I now want to take out of Book 1 the bad email address but do not want to
do
it manually (as over 4000 bad email addresses)

Any ideas please?????