In workbook 2, create a 'helper' column and put a vlookup function something
like...
=VLOOKUP(B2,[My1stWorkbook.xls]MySheet1!$A:$A,1,FALSE)
if the formula does NOT return an '#N/A', delete it as it found a match in
workbook 1.
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Pcakes" wrote:

Hi, I am trying to determine if I can cross reference 2 columns in seperate
workbooks looking for duplicates. The workbooks are not identical.

Work book 1 would be column A
Worbook 2 would be column B

I would like to delete the rows in Workbook 2 if the data in the 2 columns
in both workbooks match.

Any ideas?

Pcakes