filter data based on text entered or selected

I have an excel file where i need to be able to enter or select a value from a dropdown menu but when selected the value is then used in another sheet to automatically apply a filter to that data, So user selects value clicks a button and the filter works on another sheet.

Can't get my head around how to do this one!

With linked cell for combobox C18

Removed the merged cells

Code in macro, called with form button

Please Login or Register  to view this content.

Kind regards
Leo

Thank you that works great.

Is there a way to include a button to reset the filter?

With same button and Emty combobox

Kind regards
Leo

Thank you this has been very helpful

I have copied your code as im trying to add another filter which runs its data from the pf column but i get a 400 error when clicking the button. I'm pretty new to this so im sure it's something simple i have done wrong.

HTML Code: 

Does anybody have any ideas how i can use the code provided to make a second search field?

Thank you

Back on 22 juli
No accses to Excel till then

Cheers
Leo