Excel drop-down menu

%3CLINGO-SUB%20id%3D%22lingo-sub-1528162%22%20slang%3D%22en-US%22%3EExcel%20drop-down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528162%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20which%20has%202%20columns%20containing%20drop-down%20lists.%26nbsp%3B%20After%20data%20validation%2C%20one%20column%20works%20perfectly%20--%20the%20item%20chosen%20from%20the%20drop-down%20list%20populates%20the%20cell.%26nbsp%3B%20The%20other%20column%20shows%20the%20drop-down%20list%20but%20does%20not%20copy%20the%20chosen%20item%20into%20the%20cell.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20lists%20are%20in%20columns%20in%20an%20Excel%20worksheet.%26nbsp%3B%20The%20list%20which%20is%20not%20working%20contains%2028%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20for%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E--%20Kathy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1528162%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529230%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20drop-down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529230%22%20slang%3D%22en-US%22%3ECan%20you%20post%20the%20file%20in%20question%3F%20(please%20remove%20sensitive%20content%20first!)%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a spreadsheet which has 2 columns containing drop-down lists.  After data validation, one column works perfectly -- the item chosen from the drop-down list populates the cell.  The other column shows the drop-down list but does not copy the chosen item into the cell.  

 

Both lists are in columns in an Excel worksheet.  The list which is not working contains 28 items.

 

Any ideas for me?

 

-- Kathy

2 Replies
Can you post the file in question? (please remove sensitive content first!)
Hi,
have a look here, maybe this will help you

https://support.microsoft.com/de-de/office/erstellen-von-dropdownlisten-7693307a-59ef-400a-b769-c540...

if the link not helps you, as already answered from Jan Karel Pieterse, please download the file to see where the error is.

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)