blundastruck
New Member
- Joined
- Nov 24, 2015
- Messages
- 7
I've got a drop down list that takes the values of one sheet and uses that to display my options.
EX: I have a list of colors:
Red
Orange
Yellow
But now, I want to add Green.
I type it into my sheet, but the drop down list won't take it. The issue is the list is set to only look at the cells I told it to, but I've got WAAAAAY too many cells that use this data validation tool to change each cell to add that extra field.
Is there a smarter way I can use the data validation tool to automatically add list options? Mind you, I don't have any VBA experience but that's fine because I want to learn.
EX: I have a list of colors:
Red
Orange
Yellow
But now, I want to add Green.
I type it into my sheet, but the drop down list won't take it. The issue is the list is set to only look at the cells I told it to, but I've got WAAAAAY too many cells that use this data validation tool to change each cell to add that extra field.
Is there a smarter way I can use the data validation tool to automatically add list options? Mind you, I don't have any VBA experience but that's fine because I want to learn.