View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default Linking Drop down menus (SubCategoies)

Hi all,

Is it possible to have a drop down list in Column "B" which differs
depending on what you choose from a drop down list in Column "A"??

Ex.

Column A is a drop down field. You can choose "Floor" or "Wing"
If "Floor" is chosen, the Column B (which is also drop down) gives the
option of chosing "1st floor, 2nd floor, 3rd, floor or All"

If "Wing" is chosed, the options would be "A, B, C or D"

Thanks for your help,
Matt