Dropdown to Filter Rows Based on Value in Chosen Column

[snapfade]

Good morning!

How can I write VBA code to filter an Excel Table to show only rows that contain "x" in the chosen column?

For example (see attached), the table has one column for each month. An "x" appears in one or more of the months. When I choose "May" from the dropdown list I want to filter the table to show only rows where and "x" appears in the May column.

What complicates this is that many rows contain an "x" in multiple month columns.

Any suggestions would be most appreciated.

Thanks,
tom