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