Hello all,

I have 2 workbooks. Workbook 1 has a list of approximately 200 names arranged in column A. Workbook 2 has a list of approximately 400 names, in column A. I want to compare the list in Workbook 1 to the list in Workbook 2. I only need to know which, if any, of the names in workbook 1 are present in workbook 2. I need no other information. I have started to do it manually, but needless to say, it is taking some time. Also, I will have approximately 300 more Workbook 1's and Workbook 2's to work with, and I had to enter the information in all the workbooks, GULP, manually, and I don't type all that quickly.

If there is no easy way, then I will be forced to just put the two columns next to each other, and go through it manually.

If anyone can help, I would appreciate it. The company IT said it was too hard/not worth the effort. I bet you guys can figure it out.

Thanx
Michael