By changing a few settings, you can configure all new workbooks to automatically conform to the way you work.

You can create as many levels as you want, as long as you organize the named ranges well for seamless cascading. Make Excel Smarter With Dynamic Dropdown Lists: Here's How They Work ...