Hi I have below code which I though worked perfect. But after more tests I realize that it can make errors.
Your supposed to be able to search after customer nr, or IBAN. I though if I made the code xlWhole, it needed all digits to find a match, and then I avoided that it would search in wrong column But it can happen.
Other error is it only display on search result, even if more with same numbers.
I want it to be sure it can only search in column C2 and used rows down and column P2 and used rows down.
You input the sheet name example spain. and after the full number. Customer nr is always with 8 digits and leading zeroes.
If I now search in sheet spain with number 00000047 it only display one result even if there is 2 with that number.
If I in sheet france search for number 00017763 it give one result but its from column G. But there could be a customer number which have this number, because of same amounts of digits. So important that it only search in column C2 and down and column P2 and down.
Here is my code and also a little test sheet to work with.
Thanks Sincerely
Abjac
Bookmarks