View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Misty
 
Posts: n/a
Default How do I link mulitple drop down boxes together?

I have 2 drop down lists made, but I want to have one linked to the other
one. For example the first list has types of wood in it.
Bamboo
Maple
Oak

The 2nd one has pricing in it.
1.25
2.50
3.50

If I click on Bamboo - I want the 2nd list to auto generate 3.50. Can that
be done?