Forum

Forums
Public Forums - For...
VBA & Macros
Searched words
 
Notifications
Clear all

Searched words

 
VBA & Macros
Last Post by SunnyKow 6 years ago
12 Posts
2 Users
0 Reactions
255 Views
RSS
 Marsil Sarvis
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

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

 
Posted : 06/09/2019 12:02 pm
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Marsil

Give this a try.

Sunny

 
Posted : 07/09/2019 3:47 am
 Marsil Sarvis
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

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

 
Posted : 07/09/2019 8:14 pm
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Marsil

Hope this helps.

Sunny

 
Posted : 08/09/2019 12:39 am
 Marsil Sarvis
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

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

 
Posted : 08/09/2019 11:51 am
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

Try this

 
Posted : 08/09/2019 3:21 pm
 Marsil Sarvis
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

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

 
Posted : 09/09/2019 10:53 am
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 09/09/2019 3:43 pm
 Marsil Sarvis
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

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

 
Posted : 09/09/2019 5:04 pm
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

Hope this is correct.

Sunny

 
Posted : 10/09/2019 12:17 am
 Marsil Sarvis
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

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

 
Posted : 11/09/2019 4:25 pm
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

No problem.

Glad I was able to help.

Sunny

 
Posted : 12/09/2019 2:31 am
Forum Jump:
  Previous Topic
Next Topic  
Share: