Auto filter vba Question

prices.xlsx

Hello,

I have the attached sample file with sheets "Veri" for data entry and I have thousands of records and "fiyatlar" for monitoring.
On the "fiyatlar" sheet, I need to enter model (wildcard) to display the relevant records.
And it should display automatically when I enter more records.
On the combo box it should display distinct model names extracting from Model column on sheet "Veri"

Next, I will need to add another combo box for column "Fiyat turu" but the above will be enough for me for the moment.

Any one who can help me on this?

Thanks very much for your kind help in advance

regards
Mustafa

It is not 100% automatic in that you have to click out of the box when you enter in a value. I couldn't make it automatic on selection AND allow typing in of a wildcard. I made use of Excel tables because they automatically know their boundaries. Also it's easier to read the code when you use table names.