+ Reply to Thread
Results 1 to 2 of 2

Sort and hide rows as I type

  1. #1
    Registered User
    Join Date
    05-14-2010
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    15

    Sort and hide rows as I type

    Is there a way to imitate the search box in access where it highlights any matching text in the entire database. BUT, instead of hitting the next arrow to go to the next matching thing, I want it to simply hide all rows that contain nothing that matches. I don't want it to just hide them though, I want them to be shown from the topmost cell down rather than simply hiding cells and having a ton of gaps to look through. If this can be done in access then that will work as well.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sort and hide rows as I type

    I think that you have posted in the wrong forum. There is one for Access Tables and Databases which might be more appropriate.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. How to hide a row if it contains N/A, what type of formula would work with that?
    By lucylu600 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-12-2013, 02:50 PM
  2. Hide Rows with a Value (2 values to hide) then delete visible rows
    By Slea in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-19-2013, 06:25 AM
  3. Hide rows as you type
    By appmaster in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-08-2012, 05:06 AM
  4. Using check boxes to hide and un-hide rows with drop down lists within rows
    By Sparky_Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 07:22 AM
  5. Select rows and sort based on type
    By Sarah in forum Excel General
    Replies: 0
    Last Post: 10-11-2005, 01:05 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