search find macro

  1. B

    Searchbox in Excel

    Greetings I've been searching for a way to create a Search Box to search my Workbook. I found some code on this site, and while, it does work, there are a few things I don't like about it. Here is the code I'm using (slightly edited from it's original): I'm using Excel 2016. Sub FindRadio()...
  2. S

    Search for specific list of words in a column and return specified values in another column

    Hi There I've been searching through the forum (please feel free to point me to the right post if I missed it) and couldn't find what I was looking for so I was wondering if someone might be able to help. Trying to identify a macro that will search a column of cells for certain words and if it...
  3. H

    Look up and return a name in the relevant row Loop

    Hi I have a Column A of mixed up names (the mix sometimes contains long codes), eg. 1234_treadmill* b812 bicycle ops+keyboard rf_treadmill- b812 bicycle_87 ops bicycle_&* mouse et.<33> And I have a Column B of simple names, eg. treadmill bicycle keyboard mouse I want a macro to go...
  4. C

    Starting Search Companion with VBA

    Is there a way to do this? The user opens an excel workbook. in cell E17 on a sheet that is named "Work" is the name of the file w/o the extension. Example, file name is 123456Q1.xls in cell E17 is 123456 The user wants to find all files with 123456 in the file name in the Quote directory or...
  5. N

    Need a search function (or macro...)

    Hi I have a worksheet with 4 columns - 1 of which is employee name and one of which is employee number. I need to be able to search this list for specific names (the numbers function I can do.) The problem with searching names is we have more than 1 Bob, etc. Also, when using a name search...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top