Hi jlt,

This problem sounds like you are looking for a Cascading Dropdown. See the video at:

http://www.bluepecantraining.com/por...ists-in-excel/