I have two different files : They contain the following headers
1.

Company ID
Company Name
Contact ID
ID2003
old id
Title
First Name
LastName
Job Title
Email
Tel No
Fax
Address1
Address2
City Postc
ode Country
Account Manager
Switchboard Telephone
Number
Preferred Language

and the other FILE2 contains

Status DMC
Company ID
DMC User ID
Company Address
ZIP/City Country
countrycode
Language
First Name
LastName
Phone
Phone adjusted
Number of Calls
Result detail Result
Wave
CO
CB
Out
Available to call
Availability for Wave 9
Email address
Contact by email
ONLY Adjustments region State

The two have fields "first name " and "last name" common.I need to fin
out from the file 1 , the corresponding "ID 2003" for the common "firs
name " and "last name" and write that into the file 2,for these como
entries I have to check if the email and phone numbers have the extac
matching and in case no highlight the same in the file 2 , with
different formatting....As I do not know much programming in the V
mode..I would like any body to help

--
Message posted from http://www.ExcelForum.com