I'm just trying to solve how to use a regex pattern in vb to match a list of names in sheet 1 (Range A1:A5) with another list of names in sheet 2 (Range A1:A8) and if there is a matching name found from sheet 2 and enter this name to the corresponding matching name in sheet 1.
In sheet 1 I have:
Then in sheet 2 I have:
The spelling is a bit different in sheet 2 by some characters or one.
I'm attaching an excel sheet. Any help is very appreciated.