find variables with wildcards.

Hello,

Last year i've made a small tool which extracted some data from a large sheet.
Many people used the tool with good effort.

Now someone asked me to change the tool, instead of searching for totals, we now would like to see what everyone is selling. (and a total)

I've tried some things but it won't work. I would like to put some extra search 'n copy function between the existing code. (Between "Producten" & "Totalen Conversie")

The biggest problem is that some search strings are the same, (See "Invoerblad" in example) the only thing that i would like to search is on the first 3 numbers, when they are the same, count as the same.

Here is the code which i use to extract the totals:

Please Login or Register  to view this content.

The original file is not included, it's a bit big, If someone likes to see. send me a PM

Thanks in Advance