Hi guys... Can I get a VBA code that searches and highlights the case sensitive text in one column that matches short list (50 words) of the correct written text found on other column?
I have more than 4000 names of whatever in the column that need to search inside the correct written words. They are duplicates, most of them, but that is not the problem. They should have been written in a specific way (I have a list of them), but someone manually wrote them differently. The filter cannot make the distinction between "MIKE" and "Mike" or "miKe", however VBA is case sensitive, so must be a solution.
Can be solved without the need to invent and upload a sample file? Must be easy to understand what I ask. Thank you!
Bookmarks