Thanks for the reply mhuston but it doesn't really help me. You have to remember there will be 4000 items in the drop down menu

I really need a clickable button that opens a search box then places the resulting range of data in the corresponding row into a list that is added to with each subsequent entry into the search box.