hi
i need your help i have in sheet column 2
like Peter, RAJ
but i am comparing with other excel sheet 1 like RAJ,PETER
i am comparing sheet 2 against sheet1. here i am showing part of the code
how do i write
Code:
If Not IsEmpty(FullName) Then
intFullNameNum = InStr(1, FullName, ",")
If intEmpNameNum >= 1 Then 'Real Person's Name strEmpLNameChrUpper = UCase(Mid(EmpFullName, 1, 1))
strEmpFNameChrUpper = UCase(Mid(EmpFullName, intEmpNameNum + 1, 1))
strEmpLName = Trim(strEmpLNameChrUpper & LCase(Mid(strEmpFullName, 2, intEmpNameNum - 2)))
strEmpFName = Trim(strEmpFNameChrUpper & LCase(Mid(strEmpFullName, intEmpNameNum + 2)))
strEmployeeBothName = strEmpLName & ", " & strEmpFName
the above code shows PETER,RAJ
BUT IN SHEET 2 shows PETER, RAJ
Set M = Worksheets("Sheet2").Columns(2).Find(What:=x, MatchCase:=True)
THNAKS