The following assumes your posted macro works successfully.
:
On the Second Sheet in a BLANK COLUMN, enter the following formula on ROW #3 :
Code:
=RIGHT(B3,LEN(B3)-SEARCH(" ",B3))&", "&LEFT(B3,SEARCH(" ",B3)-1)
Now drag that formula down the column as far as there is data in Col B.
Next, edit your macro to compare against Sheet 2, Col B.