keyword search

  1. S

    search keyword in multiple word documents

    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...
  2. V

    Keyword search - Highlight Results - Hide other rows

    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...
  3. A

    working with macros: keyword search into a new sheet from my basesheet with 1000 entries.

    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...
  4. F

    Help! URL Check

    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...
  5. R

    HELP, Autocomplete search word based on Initial first/random word

    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...
  6. S

    Keyword Search to Pull Data From Different Worksheet and Place Cell Value Into Cell

    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...
  7. D

    Need help with keyword search function using SUMPRODUCT

    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...
  8. D

    SUM PRODUCT and Return Multiple Items From One Lookup Value for Table

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top