Checking if items in a table exist/match ones on a different sheet with Excel VBA.
Posted on 2014-08-11
I have a large table with data and need several columns checked for unmatched text items (items repeat) against another sheet where items are listed in various ranges and don't repeat (kind of like a set up sheet for a user). The idea is to catch data errors in the table such as misspelling of items, extra spaces and etc. Blank cells however are allowed. How one would iterate through a table column checking if each item matches either of the items on another sheet's given range and if it doesn't match have that have that cell in the data table activated and highlighted to draw user attention? For illustration purposes let's say table is "Table1" with column than needs checking "Column1" on Sheet2, and the range I am checking it against is in Sheet1 in $A$1:$A$10.
thx in advance