I am looking to have a searchable dropdown list like this one https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html
but I want it to behave like this auto complete, to overlay over any drop down I have on the sheet https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html
Maybe I am asking too much, any help would be appreciated.  Thanks