Compare Two Employee Lists

[thepartydj]

I get an updated employee list each day. Each day I need to find out what the difference in each list is. Maybe someone is missing, or someone is added. Or maybe their department changed. What is the best way to compare each of these lists to show the difference?

 

[Fluff]

Duplicate to: Help with Macro - What names are missing or added

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.