Forum Discussion
Excel SMART Drop Down List
is there anyways I can have users ADD new data in a pre existing drop down list? Example-users types in new name of a product which doesn't exist in drop down list. These new items become part of mai...
If you on Excel with dynamic arrays, spill by UNIQUE all names from data and use reference on spill in data validation.
In general google for dynamic drop-down list, lot of samples.
Thanks for your input but I have no idea what you are saying? Can you provide sample or something else so I can understand?
gdubey , you can have your items as a Table (Control-T to create the table) and use that in the data validation drop down list. See attached...
TheAntonyalso I am not adding this data in Items table. I want to add new data where you have DD list (bbb). I am assuming my data file is locked for users so they can't mess it up.
next post please
