Search List

I have a list of clients and I am trying to create a way to search the original list against a list of clients that have come into my office to see who has visited me recently. My problem is one list has husband and wife names, while the other list has one or the other or both. I need to crate a search (macro?) that creates an "IF" statement that shows YES if the client has come in recently, and be able to recognize the persons name even if his/her spouses name is not associated. EX: List 1 has Smith, John and Jane but only John Smith visited me. I need to create someway to search List 1 to recognize that John has visited me. Help please!

The sample data is in the file book gtwinter.xls which can be downloaded from this webpage

http://www.speedyshare.com/files/236...k_gtwinter.xls

You see the file(sheet "original") after running the macro "test" which is in vb editor and also given below.
if you want to recheck
run "undo"
and then
run "test"

the macro are (which are also in vb editor)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

both in the vb editor and in the above macro "undo" correct
this line

Please Login or Register  to view this content.

into

Please Login or Register  to view this content.

This may be a trivial correction.