Comparing to lists and extracting the difference

[Matthew Balch]

I have two lists which I would like to compare.

Sheet 1 = A List
Sheet 2 - B List

In Sheet 3 I would to use VB to write out all those items in the A list
which are not in the B list.

Thanks in Advance

Matthew Balch

 

[scu77]

hi

use XL_Union.xla

the way is

A = select range ... A List
B = select range ... B List

XL_Union.xla option -----> A - B

print option .... ON (what you want)

Coloring option ----OFF or ON ( if On data will be colored )

find XL_Union.xla

http://uno21.com/index2.asp?menu=forum&sub=work