Thanks for your kindly response.
Your code is perfectly working with my sample, but it's not working on the real document. I strongly believe that it's associate with the select case statement.
If I change the text from "HELLO 1 - BANANA" to something like "CAR RESALES" and change the code at the select case statement from "APPLE" to "CAR", the system is not finding anything.
The fact is that I'll never have the word "HELLO" in the third column as I wrongly provided to you in my sample document.
Please, check the following picutres for a better understanding.
Would you mind helping me again?
Thanks
|