Take a look at this:
http://www.contextures.com/xlDataVal02.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Avicayia" wrote:

I am trying to create a spread sheet for company shirt orders. I don't know
if this is possible, but I hope that it is.

I have two cells. In the first cell I have a list of available shirts that
a person can choose from. What I am looking to do is, when an individual
selects a shirt, I want the adjacent cell to generate a list of available
shirt colors based on the "Shirt" selection.

Is this possible?