Macro To Compare Two Cell Values

[jo15765]

I have an Excel worksheet where people input there name, the issue that I am running into is that some people are not properly adding in the data. So data will look like this

Please Login or Register  to view this content.

As you can see the SR was input for both the Name and EXT. To clean this up, how would I use VBA to check the value of EXT and if it exists in the Name field then update EXT to blank?

I am attaching a workbook with sample data, and my desired output to better illustrate.

Thanks in advance!

Also - this is a subset of data, the lastrow would need to be determined through the VBA syntax, not just hardcode values pulez.

[CK76]

Something like this?

Please Login or Register  to view this content.

NOTE: It is case sensitive. If you don't care about case, change vbBinaryCompare to vbTextCompare

[jo15765]

Yes, perfect. thank you.