Each month, I receive a CSV file of our client base - email, job title, phone number etc. I need to identify changes between the two sheets, including changes to existing data as well as identifying new people added.
I want to compare the new sheet with the old one, highlight the changes, and proceed from there. Email address is the most constant line item, which we often use to find people. The two sheets will always have the same columns, but the rows may be out of order making an automated side-by-side comparison hard. Is it possible to use the email address as the starting point and then work along the row highlighting data which differs?
I know VLOOKUP could be used, but surely this would mean manually scanning over the pulled through data to see if it's the same in both sheets. Perhaps I am missing something here! All software solutions I have found compare the two line by line, meaning it goes wrong the second a new person is added in/removed and the sheets become out of sync.
Any help would be appreciated.