Forum Discussion
Solved
Searchable Dropdown Lists on Multiple Rows
Is the following possible? I have not found a solution. I'm building an order form in Excel 365. I need to use the same source table for drop down lists on multiple rows. The number of rows needs...
Try a free Excel add-in called “Search deList”.
It works like this:
In any cell that has data validation (with List type) pressing ALT+RIGHT will open a searchable combobox.
Type some keywords to search, separated by a space, e.g "ma la"
The list will be narrowed down as you type.
Hit ENTER to sent the value to active cell.
You don't need VBA, so you can save your workbook as .xlsx.
You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/
You should be able to pull this off with just one combobox, which is moved into position above the current cell every time. That way, there is no limit as to how many rows the sheet has. Not sure what you mean with filling multiple columns.
