Compare range with another range in other workbook

A

Arjan

I've a workbook with names in range A1:A10.
In another workbook there is a list (the length is every week different) and
I want to compare this list with the 10 names on my first worksheet.

I want a list of the people who are in that long list, but not in my default
10 names.

I started with

For Each c In Range("[document.xls]Sheet1!E1",
Range("[document.xls]Sheet1!E65535").End(xlUp))

but that doesn't work. I don't have any idea how to solve this.

Can somebody help me or is it not possible?

Regards,
Arjan
 
B

Bob Phillips

I would use conditional formatting on the long list with a formula to test
if in the short list.

So assume the long list is Sheet2!A1:An, short list is Sheet1!A1:A10.

Select the long list, and in CF, add a formula of
=ISNUMBER(MATCH(A1,Sheet1!$A$1:$A$10,0)), and format with a colour on the
pattern tab.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bruno Campanini

Arjan said:
I've a workbook with names in range A1:A10.
In another workbook there is a list (the length is every week different)
and
I want to compare this list with the 10 names on my first worksheet.

I want a list of the people who are in that long list, but not in my
default
10 names.

I started with

For Each c In Range("[document.xls]Sheet1!E1",
Range("[document.xls]Sheet1!E65535").End(xlUp))

but that doesn't work. I don't have any idea how to solve this.

Can somebody help me or is it not possible?

Regards,
Arjan
Click to expand...

I have a VBA Sub which, given two ranges even in
two sheets, makes the following comparison:
A-B ===> elements in range A that are not in range B
B-A ===> elements in range B that are not in range A
A+B ===> elements of A plus elements of B
AB ===> elements that are common to A and B
Unique values only.

It is one page code. Do you think it is ok for you?

Ciao
Bruno
 
Top