Merge and update data from tabs.

Good afternoon.

I have a file with data in different tabs. In the tab labeled “From AD” I have an export of Active Directory. In the From SAP tab I have an export from SAP. What I want is to have a 3rd tab which is labeled “AD Updated with SAP” filled with the “From AD” information updated with the matching info from the “From SAP” tab.
The corresponding columns are labeled as follows:

From AD - EmployeeNumber From SAP – Pers.no.
From AD - WorkPhone From SAP – Work Number
From AD - Email From SAP – Email
From AD - GivenName From SAP – First name
From AD - LastName From SAP – Last name
From AD - Initials From SAP – Middle name

The email field is the unique identifier that I wish to use. Can someone tell me how to make the data merge?

I have included a test file with approximately 100 records in each tab. The real file has over 5000 in each. BTW I am using Excel 2007

Thanks!

you would be better off using Access for this task. It would be much quicker.

hi there - im having a think. So far im thinking vlookup using the email address

right, got a work around, will attach in second

hi - see if this is s-thing u can work with. Basically, its a vlookup using the email address pointing at the data you want.

BTW this is probably not the cleverest of ways but i am bound by my limited knowledge. s'one else may have a better suggestion!

I didnt do it all but enough to give you the idea, my wife needs attention!