Hide Rows based on Combo Box Selection

Hello

I am looking for a way to be able to hide all of the rows where column C does not match what is selected from a combo box.

There are five combo box selections;
U11 11v11
U12 11v11
U11 9v9
U12 9v9
U13 9v9

The selected one is put into cell F3, and the list of rows is from A6:C197. Column C will have one of the five selections in.

If column C does not match what is chosen in cell F3, I'd like the entire row to be hidden so that the user only has teams that match the chosen category.

Is this possible? And if so, please could you advise me on how.

Many thanks in advance.

Hi Dannyboy11
Welcome to the forum.
This is just the scenario that the data Filter was designed for.
In C5 apply a Filter - from the main Excel menu select the Data option.
Then in the Sort and Filter group press the Filter button.
From here you can select one of your five options from a ComboBox lookalike.
No programming needed unless you want something a little more sophisticated?

No nothing sophisticated. This worked perfectly - thanks!