Need help in finding difference in two excel

Occasional Contributor

Hi all,


I have one master database of all the employee information in excel format and one more excel sheet will come to me every day with the changes. 


I have to compare these two and find the differences and push them to a new excel sheet for my automation script to run (like comparing the status column whether the employee resigned or not, or any change in manager, department)


2 Replies
best response confirmed by Hans Vogelaar (MVP)


Quick reply, here's what you going to need.

Spreadsheet compare 

thank you