VBA | Filter Multiple Columns Based On Single Cell Value

[foolishpiano]

Hi all!

I have a named range - "States" - that are column headers. I would like to filter the columns in this named range based state selection in another cell (F1). If the State selected in cell F1 equals a state in the Named Range, keep that column visible, but hide the other columns. I'm not sure how to upload a copy of the workbook I'm creating, but I am including a screenshot of what I'm working on.

Essentially, what I'm after is if my user selects the state 'MO' in cell F1 (for example), columns E, F, G, S, and V would be the only columns visible, and all others would be hidden.

Is such a thing possible?

Thank you all for the help, as always!

 

[foolishpiano]

Hello everyone (again).

Just wanted to let everyone know that I figured out the answer to my question. This thread helped with part of it, and using the information in that thread, I came up with the following code (important note: I moved my state-selection column from F1 to D1):

Private Sub worksheet_change(ByVal target As Range)

If target.Address = "$D$1" Then
For Each cl In Sheets("Data for Checklist - Properties").Range("States")
    cl.EntireColumn.Hidden = Not (IsNumeric(Application.Match(cl, Array(Range("D1").Value), 0)))
    Next
End If

If Range("D1").Value = "" Then

Range("States").EntireColumn.Hidden = False

End If


End Sub

Just wanted to add this solution in case someone else comes along with this same question.

Thanks!