View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
khers khers is offline
external usenet poster
 
Posts: 3
Default delicate Excel-database problem

I have two files containg employee data. File "name" contains two
colons: Name and Cardnumber like this:

Andersen John, 98372839
Angell Berit, 53827384
Bang Jens, 98128493

and my second file contains two colons: Name and username

Angell Berit, angber
Henriksen Christopher, henchr

As you see some of the names appear in both files, some don't. I need
to have a file with Cardnumber (from first file) and username (from
the second file).
Can this be done? Please help

thanks in advance
khers