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
Hi Marsil
Give this a try.
Sunny
Hi Sunny.
It works perfectly.
Thank you very much; your support is greatly appreciated.
just can you help me to let this macro ignore character sensitivity
I mean don't care the upper or lower case.
macro result for TExas is the same for texas
Thanks;
Marsil
Hi Marsil
Hope this helps.
Sunny
Hi Sunny,
You are amazing! Thank you so much!
If u can fix the run-time error 13 – Type mismatch issue, please.
see attached file.
Thanks;
Marsil
Try this
Please let me know why I got this red words in macro Although "TEXAs" is part from "Texasins".
is there any wrong from my side?
Thanks;
Marsil
Hi Marsil
I think you should include as many All name scenarios as possible so that I could test it all at once.
See if this works.
Sunny
Hi Sunny,
Can you check attached result, as I added spaces in yellow space, If u can apply trim to avoid as this issue.
Thanks;
Marsil
Hope this is correct.
Sunny
Hi Sunny,
Just I would like to thank you for your info and your support.
How kind you are to help me. Thank you very much.
Thanks;
Marsil
No problem.
Glad I was able to help.
Sunny