+ Reply to Thread
Results 1 to 2 of 2

Search box and Filter

  1. #1
    Registered User
    Join Date
    12-13-2019
    Location
    Michigan, United States
    MS-Off Ver
    365
    Posts
    9

    Search box and Filter

    Short version: Looking to use a "searchbox", or just a cell for entry to search a second sheet(In the same workbook) and only pull rows that contain the partial match of the "searchbox" cell.
    i.e.
    Search.PNG

    EDIT: Going to be a bit more explanative I think.

    Currently in my Sheet 1 in cell D8, I have this formula that references D7
    Please Login or Register  to view this content.
    for a search option as follows:
    Capture46.PNG

    However when I drag and copy the row down, I get this error:
    Capture47.PNG

    The end goals is the first image, including the nearby rows all in the same table, so Sheet2!Range A:C technically. Only searching in Column A.
    There are about 25,000 entries as well, as a note.
    Is there a way I can copy this down further, or a better way in general?

    Thank you
    Last edited by rendon115; 03-06-2020 at 02:14 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Search box and Filter

    Administrative note

    As the FILTER function is not a 2010 function , please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search (filter search) a date value
    By navafolk in forum Excel General
    Replies: 6
    Last Post: 10-26-2018, 02:32 AM
  2. Replies: 4
    Last Post: 11-08-2014, 04:57 AM
  3. Replies: 2
    Last Post: 10-07-2013, 04:57 AM
  4. [SOLVED] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  5. search for a name and then filter on it
    By Migraine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2009, 02:28 PM
  6. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05:05 PM
  7. Advance filter search does not filter an exact match
    By cfiiland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2005, 08:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1