Comparing across workbooks

  • Thread starter Thread starter P.Rumpz
  • Start date Start date
P

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
 
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
 
Back
Top