I need help setting up SPECIAL drop down menus in Excel 2010.
I want (some of my) drop down menus to only contain limited choices which are based completely on the choice made in the previous column. In other words - if you choose east coast in column one - then it will only have east coast states in column two - and will then only have cities in the next columns drop down menu from the state that was chosen in the last column........... ect.
And - Can this work the same way in Access or only in Excel?
I have made a small example excel page and attached it here.