Drop down code

Hi Yisrael, My search button is working fine (thanks to your help)
what im trying to do now is add in a drop down menu that will filter thought the country’s in my data sheet. I watched vidoes on how its done but i feel like that im missing something as its not working.
I didnt post the script for it as it was broken. let me know if you want to see it or any other info that will help.

Best Noel