I have a searchable dropdown list in one workbook and When I search for something, I want to paste it into another workbook that has an identicle dropdown list. but when I do paste it over writes my second workbood drop down list.
for instance:
ford ford
bmw bmw
fiat fiat
scoda scoda
if I use the searchable drop down list and search for bmw I want to paste it into my other workbook on the order that is allready there.
I have a list of over 1000 companies which is why I want to paste it.