I'm not sure if this is possible or not, but I need to compare two columns of data on different worksheets. In my main macro, I do a Vlookup for many rows of data and I want to know if there are any cells that aren't being reported because there was no match and have this brought to my attention.
This could be done by listing all of the non-matches in a popup message or more simply (I assume), just create a new sheet called "Errors" or something and return all of the unique values.
Attached is a very simple example of what I would like to happen.
Thanks for any help or input that you may have.
Bookmarks