Hello everybody
I have large data in column A .. there are a lot of similar data ..
When use Find built-in method to find specific string, I got a lot of results ..
So I'm searching for a way to search using two string or more .. I mean I need to type in inputbox two or more strings and activate the cell that matches the search.
For example, in the attachment ...
I will type two words in input box (help search) ...
when I run the code I expect to activate A3 as this cell contains the two words ...(no matter about case sensitive)
when I run the code again .. the code to activate the next search result which is A11 (note that the string "search" is just part of the word "Searches"
Another example: if I typed in the input box two words (please me)
I expect to acivate A3 then after running again A9 then after running the code A12
if there is no results for the search to have a message
Hope it is clear
Bookmarks