Comparing two worksheets
 

I am wondering if there is a way to compare a column with
in one worksheet with a column in another worksheet. I am
trying to find the common data based upon the data
contained in the column.

Comparing two worksheets
 

you can use a formula for this

open both workbooks.

In one workbook put in the formula in B1 for example

=countif([OtherBook.xls]Sheet1!$A:$A,A1)

then drag fill down the column

Any cell in column B that has a value other than 0 matches to the other
workbook.

--
Regards,
Tom Ogilvy


"Dennis" wrote in message
...
I am wondering if there is a way to compare a column with
in one worksheet with a column in another worksheet. I am
trying to find the common data based upon the data
contained in the column.