cross referencing 2 workbooks at same time
 

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?????

cross referencing 2 workbooks at same time
 

Hi GezCam,
I am lost here, could you give an example, how do you know are bad email
addresses

"GezCam" wrote:

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?????

cross referencing 2 workbooks at same time
 

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?????

cross referencing 2 workbooks at same time
 

Hi,

How is your data set up - are there columns for First Name, Last Name,
Street, City, State, Zip? Do you have a unique identifer, for example a
social security number or employee ID?

Let's suppose column A in both worksheets contains customer ID. Then in
Book 1 create the following formula in a blank column.

=VLOOKUP(A1,[Book2]Sheet1!A$1:A$6000,1,FALSE)

If A1 is found in the list of bad addresses this formula will return the
customer ID, otherwise it will return an NA error.

Select all of these formulas and press F5, Special, Formulas and uncheck
errors, click OK. Press Ctrl+- (control minus) and choose Entire Row.

If this helps, please click the Yes button

Cheers,
Shane DEvenshire

"GezCam" wrote:

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?????