View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cristi Cristi is offline
external usenet poster
 
Posts: 1
Default Creating a List based on your choice from Another List

I have a huge problem and need help asap!! I have a spread sheet that I have
managed to figure out how to make a list in. What I want to do is, when
someone pics an option out of that list, that the next column of the sheet
will have another list that they then choose their next option from..ie

Column 1 Column2 (depends on what they pick from the drop down list 1)
List 1
Fruit
Veggies

If they pick Fruit out of the drop down list, then I want the next column to
display Cherries, Grapes, Oranges or if they pick Veggies out of the drop
down list that the next column displays a list of Carrots, Peas, Beans. I am
trying to get this set up for our companies time sheets and job tracking and
need AnY help I can get!!!! PlEaSe Email me with AnY HeLp! cristij [at]
cergillette [dot] com
Thank You ! ! !
~Cristi