

September 6, 2019

Hi All,
Really, I’m very happy to find myonlinetraininghub.com as it is very valuable and I’m sure about I will learn a lot after I joined.
I would appreciate if you can help us to create macro as I have a lot of words and I want to know if it is found in other cells or not.
Like this word “Texas” and I want to know if it is found in these words or not.
Texas Instruments Incorporated : Found
Texasins device : Not Found
The Texas Company : Found
Note: the word should be found exact not part of word.
Please can anyone help me to create macro to do this.
Input:
Column “A”, will contain the word that’s need to search about it.
Column “B”, will contain the words will search on it.
Column “C”, contain website
Column “D”, contain Year
Output:
Column “F”: will contain the found word from Column”A”.
Column “G”: will contain the names which contain the word.
Column “H”: contain website
Column “I”: contain Year
Please check Attached file to get more sample.
Thanks;
Marsil

VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016

1 Guest(s)
