Pick the old and the new workbook. Each row in the new one is matched to the old one by columns A, C and E. A row is highlighted when that match is missing from the old workbook, or when column K has a different value. The first sheet of each file is used.
No file chosen
No file chosen
Choose both workbooks to see which rows are new or changed.
Files are read in your browser and are not uploaded. Maximum file size: 20 MB. The first sheet must contain columns A, C, E and K, plus data below the header. The old and new files are never changed. The download is a copy of the new workbook as .xlsx, with the flagged rows filled in. Earlier highlighting in rows 2 and below is cleared first, as in the macro.