Excel SMART Drop Down List

Question

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 main DATA file (on a separate sheet) and they also become part of drop down list.

sergeibaklan · Answer

gdubey&nbsp;
If you on Excel with dynamic arrays, spill by UNIQUE all names from data and use reference on spill in data validation.
&nbsp;
In general google for dynamic drop-down list, lot of samples.

gdubey · Answer

Thanks for your input but I have no idea what you are saying? Can you provide sample or something else so I can understand?

theantony · Answer

gdubey&nbsp;, 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...

gdubey · Answer

next post please

gdubey · Answer

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.

Forum Discussion

Excel SMART Drop Down List

7 Replies

Resources