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