Hi,
I need to auto filter cells in column A that contains a certain text, using a selection from drop-down menu

I have column (A) with a list text values that contains "Text1" in some cells, while others don't
I need to have 2 selections in a drop down menu ("Text1" and "Others")

When selecting "Text1" , it filters rows that contains "Text1" within column (A)
When selecting "Others", it filters all other rows that don't contain "Text1" within column (A)

is that doable using a macro?

Thanks in advance