Autofilter - Supply Criteria
 

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,

Autofilter - Supply Criteria
 

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,

Autofilter - Supply Criteria
 

This will do what you want but remember K2 can be filtered out

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
myCell = Cells(2, 11)
If myCell < "" Then
Selection.AutoFilter Field:=2, Criteria1:=myCell
End If
End Sub


--
--
-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,