Similar issue to these:

[Find the differences between 2 Excel worksheets?](https://stackoverflow.com/questions/1500153/find-the-differences-between-2-excel-worksheets/1500573#1500573)

[Compare two excel sheets](https://stackoverflow.com/questions/3051610/compare-two-excel-sheets)

My issue specifically, I have a monthly employee listing with a unique ID and around 30 columns of other data for around 900 employees. 

I'm trying to accomplish two things:

1. Compare if employees were added or dropped between the lists.
2. Between the sheets for each employee compare what other data for that employee changed. i.e. Job Title changed.

Most compare add-ins/modules I find only compare the specific ranges in order, thus once once difference if found every subsequent row will be different. 

First, I'm wondering if there are any existing tools that can do this. If not I was thinking of building my own. I was thinking of doing this by looping through each employee and using vlookup to verify matches. I'm concerned doing this many loops will make the macro difficult to use. Any guidance on how I should go about this? Thanks.