It would jump around a lot because it would have to check that cell
everytime anything moved or changed, a button would be better but by the
time you did that you could just use the built in Custom functionality.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"JMay" wrote in message
...
I have an auto-filter table in Range A1:F8 (with Row1=header)

My Column E is 2-Character State (TX, NC) (Range E2:E8)

Can I enter into Cell K2 a Value say, NC which will
Instantly Filter my Range with only my NC records?
If so, how could this be done?

TIA,