Forum Discussion
Excel SMART Drop Down List
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.
gdubey , I'm not sure I understand completely what you are trying to achieve. Can you provide an example file (confidential content removed)?
TheAntonysure..lets say I am building a some sort of Billing form where I have columns like date, manager name, account numbers, departments etc etc. All the data for this billing form located in different sheet and I am using vlookup formula so when someone selects the department, departments account number pop ups in 2nd column. Here is my problem----
My data is going to change all the time-means new managers will be added, new account numbers will be created, etc. How do I do that? I don't want to go and add stuff in this form manually all the time. Rather, I want to have USERS add it BUT not in my master DATA file (sensitive data). I want them to add right in Billing form. So, eg.-they type some info in DD list for department and if the dept. is not there, they type it and it gets added to master data and to this DD list.
next post please