Debra Dalgleish covers everything!

http://www.contextures.com/xlDataVal02.html

Hope you don't mind me posting for you!

"KJ" wrote:

I want to create a drop down list based on another drop down list. Is this
possible? For example, I have several branch locations. When one is choosen
from a drop down list, I want to have another drop down list that pulls route
numbers for that branch only.