Find differences after monthly updates

[MizGrace]

Our home office sends us a spreadsheet of everyone that has been hired, changed roles, or left the company every month. I am trying to figure out the fastest way to compare the changes from last month's spreadsheet to this month's. Attached is a sample of what we get every month. The actual doc is about 8000 rows. Thanks for your ideas!

[alansidman]

To give you a workable solution you would need to provide two worksheets. Prior Month and Current Month. I suspect you can do a join in Power Query (Get and Transform in your version of Excel) on the common field and determine the differences.

[MizGrace]

Thank you, I attached another one with some changes to it that we typically see.

[oeldere]

With this pivot table, you see which data are updated.

See the attached file.

[MizGrace]

Thank you - that is helpful. What I would like to see is a way to see a way that highlights the changes.
So, if an address changed I would see that highlighted. If a status changed that would be highlighted. If a new person was added, they would be highlighted.

If there was some way to show me what was added and what was changed since the previous month, that would be very helpful.

Any ideas on something like that?

[JeteMc]

I suggest that the two monthly sheets be placed in the same workbook.
As for changed since the previous month conditionally format the cell amber using: =INDEX('Month 1'!B$2:B$6,MATCH($A2,'Month 1'!$A$2:$A$6,0))<>B2
As for added since the previous month conditionally format the row yellow using: =COUNTIFS('Month 1'!$A$2:$A$6,$A2)=0
Note that the rules need to be in the above order.
Let us know if you have any questions.