I'm very new with VBA, and I can say I'm quite bad, so, please, accept my apologies if I will be not so technical.
I've a very nice VBA code, that somebody else provided to me few years ago, designed to:
1) compare two columns in two different sheets : column B in "Master List" against column B in "new" lists where I'd like to find out all the existing matches (match=value in B/Active Sheet that "contains" or "correspond to" one or more values in B /Master List (so the match in B/Active sheet is 'equal to' or 'greater than' values in B/Master list - all the possible results, not just the first one)
2) A new worksheet is created listing all the results
3) results in the "Active Lists" and reference values in the Master List are copied in the new worksheet among with data in their same rows (let's say from column A to column G)
You can find VBA and an example of what I need in the attached file.
As you can see i have a long list of "values" in the Master list and they can be text, numbers, sometime short sometime very long, starting with zero, and so on.. the can be quite different values types, The same is for the values to "analyze" in the active worksheet.
I didn't use this VBA for a while but now I need to use it again and I added some new "value" in the Master List.
Unfortunately it doesn't work as expected.
To check its performance I've copied from the Master List 10 "Controls" and I've seen that the Macro is not able to find all of them:
It doesn't find matches for
As you can see in the sheet "All_matches_8.32" if you filter for CTRL or for Blue rows.
I can't understand why.
Please could you help with this?