I need help with a macros to compare column "O" in two sheets:
Find Stock Symbol sheet
and Stock & Symbol Data sheet.
Here's a sample file:
Company Name3.xlsm
The code I made below works, but it only matches the first instance of a match and doesn't consider any other matches. I appreciate any help you can give.
Another more experienced member had mentioned that it's possible to make a code that finds all matches and puts them into a userform which pops up and the user can click on which is the best match.
For example:
Which company is the best match?
[] Coca Cola
[] CocaCola
[] Coca-Cola
etc.
Bookmarks