Comparing across workbooks

[P.Rumpz]

Hello,

I wish to compare a Master worksheet A to a second worksheet B store
in a separate workbook, where column X is 'SSN' on both sheets. I wan
to create a list (SSN, LName, FName) on a SUMMARY sheet for all SSN
that do not appear on -both- A and B. SSN is a unique value for eac
person.

Right now I have 8 separate worksheets, all saved in one workbook, tha
I need to compare to the Master. I am thinking it may be easier t
compare each sheet individually (creating 8 SUMMARY sheets) to th
Master rather than comparing them all at once to the Master and havin
one grand SUMMARY sheet. Am I correct in thinking this?

Can anyone help?


Thank you

 

[Frank Kabel]

Hi
as a starting point you may have a look at
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[P.Rumpz]

Hello again,

Yes, it is a start, but I am not entirely sure how to handle th
comparison of data ranges across multiple sheets/workbooks. I a
wondering how the function would have to be modified to accomodate fo
this?

Thank you.

P