Oct 07 2022 07:23 AM
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 to be easily expandable (copy and paste), so a combo box is not an option. The drop down list needs to fill multiple columns on each row. Additionally, the drop down list needs to be searchable, as the source table will contain thousands of entries.
There are plenty of solutions online using a combo box, but the multi-line, expandable requirement seems to rule this out. Or maybe I'm just missing something. Can anyone suggest a solution for this?
Oct 07 2022 07:55 AM
Oct 07 2022 09:54 AM
SolutionTry 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-searc...
Oct 07 2022 10:16 AM
Oct 07 2022 11:02 AM
Oct 07 2022 09:54 AM
SolutionTry 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-searc...