vba to match names between 2 columns

[saravanan1981]

Hi,

In Sheet1 I have some with First name & Middle name & Last Name and also with first name & Last name.

In sheet2 I have some name some names which contains some names in sheet1.

In sheet2 I wants to check whether the Names are Matching with Sheet one or not By Comparing all permutation and Computation. Means Some name might contains first name in middle and middle name in last and last name as first vice versa.

Also Pull the member code if name is matching

Kindly provide vba code for the same.

[MickG]

Try this for results in sheet2 starting "C1"

Please Login or Register  to view this content.

Regards Mick

[sktneer]

Or you may try something like this....

Please Login or Register  to view this content.

[saravanan1981]

Thank you very much for the code. Its working perfectly.

Can you please provide code for below thread as well?

http://www.excelforum.com/excel-prog...ween-rows.html

[sktneer]

You're welcome. Glad we could help.
Thanks for the feedback as well.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[saravanan1981]

Hi,

Sure, Marked as SOLVED. Please help me with code for below thread.

http://www.excelforum.com/excel-prog...ween-rows.html