I have 2 workbooks and want to compare Column A in both books. If there
is no match for an item in WB1 Column A to WB2 Column A, I want to
highlight or insert a cheater column in WB1 indicating "not in WB2".
Similarly, if something is found in WB2 and not in WB1, highlight in a
different color or "not in WB1". TIA
Greg
Bookmarks