Jump to content
Sign in to follow this  
brucebru

Search for a word in a column of a Excel sheet

Recommended Posts

brucebru

Greetings,

I am looking for a script to search for a specific word in a specific column of an opened Excel document.

Once he found the word that i'm looking, I need to see all ligne with that specific word inside.

I try many many script from this forum but I still can not find a solution to what I am looking for.

Any help will be a lot appreciated.

Thank you

Edited by brucebru

Share this post


Link to post
Share on other sites
JLogan3o13

Hi brucebru, welcome to the forum. You mention you have tried many scripts from this forum, how about posting what you have so far? We are not in the business of writing code for you, but we're happy to help. To begin with, I would suggest some light reading in the help file under _Excel, or you can use Water's great ExcelEX UDF:

Edited by JLogan3o13

√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites
water

You could have a look at my ExcelEX UDF (for download please check my signature). Function _Excel_RangeFind should do what you want.

But be warned: Its an early alpha version subject to changes!


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
brucebru

JLogan3o13, water, thanks a lot for your reply, I am going to take a look of what you suggest me :-)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×