Two columns titled "Unit1" and "Unit2" in the header row (row 1).
These columns CANNOT be referenced by letters as they randomly change which column they are in, they must be found via text match.
Need to compare, row by row, the values in both columns.
If on any row, the value in the "Unit1" column = "Unit2" column, then highlight that entire row yellow.
Dim numberofduplicaterows as integer
set numberofduplicaterows = (the number of duplicate rows)
if no duplicate rows found then do nothing.
Bookmarks