Thread: Drop Down Lists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Robinson David Robinson is offline
external usenet poster
 
Posts: 2
Default Drop Down Lists

I need to create a drop down list, that changes selections, based on the
value of a different cell. For instance, if the value in the key cell is
Apples, then the drop down list will have different kinds of apples for the
selections. If the value in the key cell is Peaches, then the same drop down
list will now show different kinds of peaches for the selections. How is
this done?