Hi all -
I have a sheet with multiple columns utilizing data validation drop-downs. I need the drop-downs to be searchable due to the large number of options in the drop-down lists [Country column for example]. I understand there are limitations with data validation and this can be done with Comboboxes. Unfortunately, I am unable to email Macro-Enabled workbooks so Comboboxes are a no-go. Is there some kind of workaround to solve this?
Really hoping one of you excel guru's can help!! Thanks everyone in advance.