keyword search

Hello, I need to search a keyword across multiple word documents saved in a folder. There are hundreds of such documents and its impossible to open each doc and search for the keyword. I am looking for an excel macro which will go into each of the word documents and return the name of the...

Dear Excel Experts I adapted a conditional formatting Macro for my purposes. It works now with an inputbox quite neatly and highlights the cells where the keyword is found. However, I want to hide the other rows where the keyword isn't in. I don't know if that's even possible with this code...

hi..i am very new to excel and with macros as well..but i want to know if I am having a spreadsheet with around more than 1000 products in a single column and a corresponding column with another value and i want to create a list of 10 products from the base sheet into a new worksheet by only...

Hello, It is possible that I wanted Macro to check my URL's list in sheet1 to: 1. Scan the website for my keywords list 2. If "0" stock, put text "not available" 3. If product is found, put text "available" 4. The result show in sheet2 5. Repeat until all the URL in the sheet1 are checked For...

Hi All, I've been looking anywhere but I couldn't find the solution, please help. My problem is i want to do autocomplete search based on these condition 1. initial first or random word that contained in the list data. 2. the search result will be auto sorted from A to Z, not case sensitive...

I’m trying to create a macro that will search for certain “keywords” from C9 down to the end of the printable area, since the area grows if new rows are added, or to where there is no more data in the B&C columns (whichever is easier to code). I want the cell in the next column (D) that had a...

Hi I am trying to set up a keyword search where someone can type a word in D8 and the number of books with that word in its title will be returned. I have managed to get the following sum to work if I put the exact title in the search however I would like it to be possible for a partial search...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I used the video <o:p></o:p> "Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table" to create a great lookup devise. <o:p></o:p> <o:p></o:p> I would like to set up another...