ThrottleWorks
Excel Ninja
Hi,
Please see attached file for your reference. Column A is the key word to be searched. Column D is the Text to be searched from.
I am trying to write a macro for below requirement.
Column D will have different text values. Each cell will have different text. This text can be multi line or single line.
I have a list of key words, please see column A. I need to check if any of the key word is present in each cell.
For example range D2 has key word 'Dummy 1' present, macro needs to identify and highlight this key word.
Each cell from column may have one key word single time, multiple times or multiple key words single time or no key word at all.
Please see range D16, this cell has 'Dummy 7' key word twice. Range D9 does not have any key word.
How do I do this, can anyone please help me in this. Take care.
Please see attached file for your reference. Column A is the key word to be searched. Column D is the Text to be searched from.
I am trying to write a macro for below requirement.
Column D will have different text values. Each cell will have different text. This text can be multi line or single line.
I have a list of key words, please see column A. I need to check if any of the key word is present in each cell.
For example range D2 has key word 'Dummy 1' present, macro needs to identify and highlight this key word.
Each cell from column may have one key word single time, multiple times or multiple key words single time or no key word at all.
Please see range D16, this cell has 'Dummy 7' key word twice. Range D9 does not have any key word.
How do I do this, can anyone please help me in this. Take care.