Compare & create list of uniques across books/sheets

[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 provide some assistance?


Thank you

 

[Tom Ogilvy]

Don't see any advantage in preparing 8 summary sheets unless you need the
information on separate sheets. You can always mark each row as to what
sheet was compared to master.