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


--


Regards,


Peo Sjoblom



"Heather Fabries" <Heather wrote in
message ...
I have a drop down list in one cell with answers a, b, and c. I would like
to have a drop down box in the cell next to it that gives choices based on
the choice made in drop down list 1. For example, if I click on (a) in
the
first drop down list, I would like tha choices 1, 2, or 3 in the 2nd drop
down list. If I click on (b) in the first drop down list, I would like tha
choices 4, 5, or 6 in the 2nd drop down list. Is this possible in Excel
2007?