I have 5000 rows of first name, middle name and Last name in two different
workbook. How do I compare the names in the first workbook with the other
workbook and create a "Yes" response in another column next to those not
found in the other work book.
Some names have middle name in one work book and the same name may not have
middle name in the other workbook. Can macro do this? if so that will be
awesome..

PLEASE HELP ME, I WILL REALLY APPRECIATE IT, THANKS A LOT