SOLVED

Need help in finding difference in two excel

Copper 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)
Solution

@imsureshbio1109 

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

Spreadsheet compare 

thank you
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@imsureshbio1109 

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

Spreadsheet compare 

View solution in original post