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
Bookmarks