Look at VLOOKUP - this will link the two files. Come back if you have
questions; we can show you how to use Paste Special to break the link
between the two files
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Angela" wrote in message
...
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?