I'm trying to create a validation list using a range name capability in order to dynamically change the selection from the list box.
I've attached a mock up.
The List tab is the list that will expand and contract (adds and deletes). That needs to show up in the Validation Tab when you drop down The List.
Your help with this is much appreciated.