Hi Jonathan,

Can you clarify? You have two *workbooks* (Excel files), or two *worksheets*
(ie, in the same file).
A little info about the kind of data they hold may help - is there a column
in each that is designed for unique values? Are the columns in the same
order?

Thx
Roger



"jonathan182" wrote in message
...
Hi I have 2 spreadsheet workbooks in excel, and I want to see if there is
any
data that is in both of the spreadsheets. Is there a way of linking the
two
to be able to find the duplicate data or any other way for that matter?

Please help!