Quote:
the above code shows PETER,RAJ
BUT IN SHEET 2 shows PETER, RAJ
|
Code:
strEmployeeBothName = strEmpLName & ", "& strEmpFName
sorry, but the above code shows PETER, RAJ not PETER,RAJ as you say (look at the line 7 in your posted code)
at this row in your code, it says : put between the last name and first name a comma and a space... if you don't want a space between names, just delete the space after the comma...
and you can change in your code the lower case to upper case to match the format in the other sheet...
How do you want to use the results of this comparison?
(maybe if you upload a sample with data and desired results, will ease communication...)