Implementing a row which "finds" rows which match it

Hi Blechy,

You could filter your data manually as suggested above, or do it automatically whenever you modify a special filter cell in row 1 (see the attached spreadsheet).

Use A1 and B1 as your field filters (e.g. type Cat in A1 and it will filter all cats. Delete A1 and all records show up again. Type Feet in B1 and it will filter for that value.)

If you type in a value that doesn't exist, all values will be filtered (no results). You can simply delete or replace that value with a different one to get different results.

This method could be expanded for additional columns. Be sure to change any range references to suit your data set.

Please Login or Register  to view this content.

hi all,

Blechy,
Debra has some good explanations for the use of either Autofilter or Advanced Filter on her website:
http://www.contextures.com/tiptech.html

If you want detailed filter tool you could try Ron de Bruin's "Easy Filter" addin:
http://www.rondebruin.nl/easyfilter.htm
or for something with a little less grunt you can import the attached Quick Filter file into your "personal.xls" file so that is available whenever you open Excel.

This Quick Filter code is something I've written and use every day using a shortcut combination of [ctrl + q]. It still has the occasional glitch when it doesn't always filter dates properly but on the whole it works well & is fast to use with the keyboard (no need to flick through the tabs which are on Ron's popup).

Paul/Steve/others,
It works for me almost all of the time so I feel if it ain't broke don't fix it ;-)However, if somthing jumps out at you, feel free to make suggestions on improvements to the Quick Filter coding - esp around the messy coding I have for checking for date values in the active cell. Also, I've had problems when trying to turn it into an addin (I'll read up on it one day...) which is why I just have it in my personal xls.


Paul,
Does this line of code always work for you?

Please Login or Register  to view this content.

I've had problems with this principle in the past & I had to Set an "IntersectionRange" & then use that in the If statement (see the attached file).

hth
Rob

Hi Rob, to date I've not experienced any problems using the 'If Not Intersect(Target,Range(..)) Is Nothing' code you mentioned, but that's not to say it couldn't be a problem in certain situations.

hi Coltrane59,

Welcome to the Forum

Have a look at the code in my previously uploaded zip file which does allow for filtering on partial matches.
If this is not sufficient, please start a new thread (as per Forum Rules) & include a link to this thread if it is suitable.

hth
Rob