macro for filtering a column which contains certain value

[SR_excelhelp]

Hi, I am trying to create a budget template and send it out to many people who will filter their country, sector etc , so, I want a button on top , which says if this is equal to XYZ , then filter col A containing XYZ , is there a way to do this , preferable without macro/vba?

 

[HERMONES]

You can create a macro to easily do that, but then you said you dont want to create a macro.

I dont know too much about slicers but maybe that would be another option, but the data would have to be in a pivot table I think to be able to do that.

 

[HERMONES]

You can put this code onto a button, but you will need to adapt it to suit your needs:

Sub Test()
'
' Test Macro
    Selection.AutoFilter
    ActiveSheet.Range("$B$1:$B$15").AutoFilter Field:=1, Criteria1:="XYZ"
End Sub