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

--
Message posted from http://www.ExcelForum.com