Excel 2007 question

[Josh]

To all,

I am looking for a way to have a text field in excel 2007 where I can type in a value and have excel filter out all rows that do not contain that text.

Does anyone know of a way to do this in excel 07?

Josh

[Darwin]

ASAP Utilities is a fantastic, free Excel add-in that should allow you to do this, although I suspect you already have it installed and that I've misunderstood what you're after 

[Target]

advanced filters are supposed to be able to do this, though having said that I've never been able to get it to work...

You could write an on change routine to amend the existing filter criteria though