Searchable Drop Down List-Multiple Lines

Hello,

I built a searchable drop down list in excel which will help me to create quick receipts from a huge list of products.

I entered my products in one column and their respective content and price in the columns next to it.

My goal is to create a searchable drop down list which will include all of my products so that when I search and select the product my customer ordered it will ultimately pull the content and price with it to form a receipt with multiple products.


The problem I ran into is that my searchable drop down list cannot be copied to the multiple rows below.

Cell B8 is active.

Does anyone know how to get around this issue?

Your help is greatly appreciated.

EFS receipt drop down.xlsx

I appreciate the help. I may just end up creating multiple columns to reference so that the searchable dropdown will function in each row.

Thanks again.

Hi.. how are u..
I hope u can read this msg.. I just wanna ask u how u ended with the Searchable Drop Down List-Multiple Lines

Here are 2 links that may help.

HTML Code: 

HTML Code: 

I have used both and they work fine.

Jim O

i KNOW ABOUT THIS.. Whar we want is a multiple searchable drop down list so that u can use searchable drop down for other cells.. not only in one cell . the search must be for multiple cells

Hi Sallabis

Have you managed to find away to use a searchable drop down list on multiple lines ?

Best Regards.