+ Reply to Thread
Results 1 to 6 of 6

Multiple search criteria from table

  1. 01-28-2016, 05:41 PM #1
    getmemickey is offline
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14

    Multiple search criteria from table

    Hello All, apologies if this is in the wrong section but I believe I need VBA for this.

    Is there a way to search a table by typing into a search box (ideally placed above the table), with the ability to type multiple search terms and filter out all rows which do NOT contain those terms?

    Example attached.

    I have looked everywhere but after days of trying cannot get anything to work correctly! I believe I would need VBA and the search box would be an active X control.

    Good Luck! and thanks!

    Mickey
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-28-2016, 06:22 PM #2
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Multiple search criteria from table

    See attached. Multiple search parameters separated by a comma. Note: There are other options but since you asked for a specific result.
    Attached Files Attached Files
    Last edited by stnkynts; 01-28-2016 at 06:25 PM.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  3. 01-28-2016, 06:23 PM #3
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Multiple search criteria from table

    Hi there!
    Do you have difficulties using the Excel Filter functionality?
    Click anywhere inside your table and click Ctrl+Shift+L
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you
    Reply With QuoteRegister To Reply
  4. 01-29-2016, 10:44 AM #4
    getmemickey is offline
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14

    Re: Multiple search criteria from table

    This doesn't appear to be working? I have enabled Macros but to no avail...
    Reply With QuoteRegister To Reply
  5. 01-29-2016, 11:10 AM #5
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Multiple search criteria from table

    This doesn't appear to be working? I have enabled Macros but to no avail...
    It works just fine. Did you actually run the macro after you typed stuff into the textbox?
    Reply With QuoteRegister To Reply
  6. 01-29-2016, 11:14 AM #6
    getmemickey is offline
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14
    Quote Originally Posted by stnkynts View Post
    It works just fine. Did you actually run the macro after you typed stuff into the textbox?
    How do you run a macro? Sorry....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create User form to perform search using multiple search criteria
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 06:16 AM
  2. Create a search userform to search using multiple criteria
    By Aleemaher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 09:17 AM
  3. Creating Multiple search tool (currently single criteria search) and reporting to Main Pag
    By Gluv1983 in forum Excel General
    Replies: 4
    Last Post: 05-20-2014, 10:03 AM
  4. how to search multiple col/row table wit multiple criteria to return lowest value
    By Mitchellt in forum Excel General
    Replies: 5
    Last Post: 06-21-2012, 10:36 AM
  5. Search Multiple Worksheets Against List of Non-Exact Search Criteria?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 03:46 PM
  6. Search table with multiple criteria and return row
    By grunwaldlove in forum Excel General
    Replies: 2
    Last Post: 11-11-2009, 11:18 AM
  7. How do I search excel spreadsheets using multiple search criteria.
    By Kasper in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2005, 08:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1