Forum Discussion
Greekbob
Jul 16, 2020Copper Contributor
Excel drop-down menu
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
- NikolinoDEPlatinum ContributorHi,
have a look here, maybe this will help you
https://support.microsoft.com/de-de/office/erstellen-von-dropdownlisten-7693307a-59ef-400a-b769-c5402dce407b
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) - JKPieterseSilver ContributorCan you post the file in question? (please remove sensitive content first!)