Searchable dropdown list problem


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.



This site is about teaching Excel. It isn't about free code writing, nor is it about free system consultancy. What would you like to learn about Excel?
Variatus (rep: 2205) May 2, '17 at 11:26 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login