I have got 2 workbooks with a list of names. I need to find out if a name
appears in both books.
One of the workbooks came from a different source and the other one is a
report I ran from our database.

I need to find out whether the workbook from out of the company has got any
of our own names on it.

I am using Microsoft Excel 97 and am fairly new at this so please be gentle.
One way I did think was to combine the two workbooks into one and find the
duplicates but thought there may be another way.

Thank you.