Compare two sheets using Key cell

[deepslp]

I know this has been asked a thousand times, but my case is a little different. I have a workbook with a master sheet and then a sheet where people make updates to the data provided from the master sheet. Sometimes they add rows and some times they remove rows, change data in row cells etc. the constant is the application number in column A. This will match the application number in the master sheet in column a. I would like to hilight the changes made in the Input sheet when compared to the master sheet.

 

[alansidman]

This can be achieved using Power Query to join the two ranges/tables based upon the common field.

Excel Power Query Combine Tables Merge Table Data

Easy steps combine Excel tables from different worksheets. Use Data tab or Power Query tab commands to merge data. Create pivot table from combined data

www.contextures.com