I have 2 collections. A master and an input.
I need to compare the input against the master to see if any changes have occurred and highlight the specific cell in excel to indicate where the change is.
The master has 77 columns and 770 rows.
The input has the same number of columns and rows however the data in the cells may be slightly different.
All recommended solutions only check the full row and give a true false decision.
I need to check every cell in the row and do a true false decision on the result.
Then I need to be able to identify the cell range that is referring to so i can highlight the incorrect cell in the input.
I need to compare the input against the master to see if any changes have occurred and highlight the specific cell in excel to indicate where the change is.
The master has 77 columns and 770 rows.
The input has the same number of columns and rows however the data in the cells may be slightly different.
All recommended solutions only check the full row and give a true false decision.
I need to check every cell in the row and do a true false decision on the result.
Then I need to be able to identify the cell range that is referring to so i can highlight the incorrect cell in the input.