Merge 2 workbooks with similar data into one

[bellina03]

Hi everyone

I have 2 workbooks, employee lists - one dated 31 Dec 2014 and the other 31 March 2015. During this time we changed the program we use to maintain our employee records which has resulted in the 2 spreadsheets reporting slightly different information for each employee. Also in the last 3 months we have had staff leave and new staff join.

For a project I am working on I need to merge these 2 workbooks together to create 1 master employee list which contains all the columns of information for each individual person (row). I have provided you with the columns of information I have to work with as well as a sample record.

I don't mind if I have to create a brand new workbook/worksheet to act as the "master" - I just need to be able to accurately merge the 2 into one master as there are over 2000 records and really want to avoid doing this manually.

Any guidance/assistance from any guru out there is greatly appreciated.

Cheers, L

[LokeshKumar]

Hi,

I have seen your files......
You can put all employees idea together and then apply advance filter and lookup all the other values then......