Hello,
I am trying to compare two columns on different worksheets.
The problem occurs when I am trying to compare namesin column B.
This is what Ive got so far, please ignore my messy code.
Macro wont do
unless names match 100% but I want highlight them even it is comparing switched first and last name.
For example:
John Smith on activesheet will be highlighted when John smith is somewhere in column B on other sheets BUT
John Smith will not be highligted on activesheet when on othersheet he is stored as Smith John.
Can you please advice me how to proceed?
Thanks in advance!
Bookmarks