Hi,
Try out this raw solution. You mentioned that original data contains ~15k rows, so loop and compare cells might be quite slow. All data processing is in arrays.
My logic for this compare is:
1) Get array with all headers of Table2 (this one probably will contain less data, but all columns in this table must be found in Table1).
This array includes number of corresponding column from Table1 (as soon as columns can be mixed and order is not the same as in Table1).
Basically "Name" (header of Table2), 10 (that means that in Table1 column "Name" is number 10)
2) Find and write to variables numbers of 'FileNumber' columns (FileNr1 and FileNr2)
3) Transfer both tables into arrays
4) Loop through array (with Table2 data) and compare data with another array (Table1 data) + write result of this compare to separate array ( Result() ).
5) After all data is compared (inside arrays this should be fast enough) loop through Result array and fill cells with colors.
Bookmarks