Comparing to lists and extracting the difference

's Computer Specifications

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

's Computer Specifications

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

"Matthew Balch" wrote:

> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two lists and extracting data from one to another	=?Utf-8?B?Q2xlbWVudA==?=	Microsoft Excel Worksheet Functions	2	12th Jan 2006 06:38 PM
Comparing files and extracting info.	=?Utf-8?B?T3RpbGxpbw==?=	Microsoft Excel Worksheet Functions	8	7th Dec 2005 01:06 AM
Comparing and Extracting unique Values	ntesic	Microsoft Excel New Users	1	16th Aug 2004 05:27 AM
Comparing Lists to Partial Lists	depuyus	Microsoft Excel Programming	0	5th Aug 2004 01:43 PM
Comparing and extracting from two columns	=?Utf-8?B?TG91bmVy?=	Microsoft Excel Misc	1	18th Oct 2003 06:31 AM