+ Reply to Thread
Results 1 to 3 of 3

Automatically pull rows to top of sheet that contain matching cell information?

  1. #1
    Registered User
    Join Date
    01-09-2025
    Location
    Davenport, Iowa
    MS-Off Ver
    Standard 2019
    Posts
    1

    Automatically pull rows to top of sheet that contain matching cell information?

    I have a document that I am slowly populating with data that is proving to be a bit of a chore when locating information previously entered that needs to be updated and I was wondering if there is a formula or function that may help me?

    Question:
    When I enter the “Inspection I.D.” into cell A2 (highlighted), is it possible for the matching row/rows to be automatically raised up to the top of the page to be quickly located and updated with the correct information?
    There are actually 4 matching rows to the example provided here on rows 322-325.

    Info:
    The “Data” tab you see here has less than 10% of the information that will eventually be entered into it. I am quickly seeing that scrolling down to locate a row or rows that need to be updated is becoming a bit of a time suck.
    Updates often include any/all of these rows (plus some that I have removed).

    Help!!!
    Joe
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,658

    Re: Automatically pull rows to top of sheet that contain matching cell information?

    In the searchbox of the filter you can type whatever you want to see
    filter.jpg
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,844

    Re: Automatically pull rows to top of sheet that contain matching cell information?

    Filter on the value in A2

    Click on filter "arrow" >> Text Filters ..Equals .... Copy/paste value in A2

    Beaten to the draw!
    Attached Images Attached Images
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. [SOLVED] Pull information from Sheet if Cell is blank
    By jomili in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-07-2019, 01:04 PM
  2. Replies: 19
    Last Post: 01-02-2018, 10:25 PM
  3. Replies: 3
    Last Post: 12-10-2015, 02:50 PM
  4. Copy complete rows matching criteria to another sheet automatically
    By abdulahadzafar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 12:09 PM
  5. Automatically pull information from a website? API?
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2013, 11:55 PM
  6. Replies: 19
    Last Post: 05-13-2013, 01:08 PM
  7. Macro to Pull information from one Excel Sheet based on information in another sheet
    By IwannabanExcelGod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:11 PM

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