I have 2 workbooks. The first workbook is a compilation of approximately
15,000 contacts. The second workbook is a copy of the first. Someone
eliminated a very important column in the second workbook. This column
contained the employee name that the contact originated from. I can not just
go back and paste the original column in to the second workbook, because
there have been multiple revisions, deletions and additions to the second
work book.

I need a way to match each name in the second workbook to their name in the
original workbook so that I can capture the origin for that contact name
which is only contained in the first workbook. Any idea how I can do that?