I have data in two work sheets and need to merge the worksheets into one based on the employee id. any help with VBA is much appreciated.
work sheet1:
Name Emp id DOB Address City State
John 1234 8/1/1970 123 main st detroit MI
Eric 5678 11/12/1976 456 cass av chicago IL
Tim 9876 12/1/1975 722 wayne cr New York NY
worksheet2:
Empid Current title Department Office
1234 Sales Manager Dept1 Office1
5678 Marketing Exec Dept2 Office2
9876 Analyst Dept3 Office3
Expected result:
Name Empid DOB Address City State
John 1234 8/1/1970 123 main st detroit MI
Current title Sales Manager
Department Dept1
Office Office1
Eric 5678 11/12/1976 456 cass av chicago IL
Current title Marketing Exec
Department Dept2
Office Office2
Tim 9876 12/1/1975 722 wayne circle New York NY
Current title Analyst
Department Dept3
Office Office3
Bookmarks