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" <Angela@discussions.microsoft.com> wrote in message
news:90D2D495-E1BC-4909-9E9C-5D5357B66F29@microsoft.com...
>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?
>