Good day,
I have a list of key words in column A (134 of them) i.e. "Red roses, Black car, etc" and I am looking to paste a range of data (text) in column B.
What I'm looking to accomplish is the ability to locate and highlight the cell within Column B that would contain the specific words "Red roses, black car, etc" that are located in the list on column A.
In the event "car, black, Red etc" are located in B, the script would skip these.
Any quidance or assistance is greatly appreciated.
I have a list of key words in column A (134 of them) i.e. "Red roses, Black car, etc" and I am looking to paste a range of data (text) in column B.
What I'm looking to accomplish is the ability to locate and highlight the cell within Column B that would contain the specific words "Red roses, black car, etc" that are located in the list on column A.
In the event "car, black, Red etc" are located in B, the script would skip these.
Any quidance or assistance is greatly appreciated.