Please see the two workbooks attached. In Book 1 column B has a list of names and Book 2 column C has a list of names. Some are common, some are not. The macro should, in Book 1, compare the names in column B (from Book 1) with the names in column C (in Book 2) and populate the result in Book 1. Where the names match, it can return"OK" and where the names do not match, it can return "Not Found". Since this list of names in both spreadsheets can be long, it would be nice if Excel could check row after row till it finds a blank cell and then stop.
Bookmarks