Hi
When using validation for a simple list like this, I usually colour the cell, just to highlight it.
The other item you are talking about is cascading comboboxes. There is an excellent discussion of this technique here
http://www.mrexcel.com/forum/showthread.php?p=126
When using validation for a simple list like this, I usually colour the cell, just to highlight it.
The other item you are talking about is cascading comboboxes. There is an excellent discussion of this technique here
http://www.mrexcel.com/forum/showthread.php?p=126