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.



Please Login or Register  to view this content.