View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default Creating Drop-down menus with subset drop-down menus

I'm creating an excel sheet with drop-down menus using validations. I'd like
to create a second row that looks up a list of equipment types from the first
row's selection. i.e. column 1 = pumps, electrical, vessels.
column 2 = types of pumps,
or types of electrical
or types of vessels.
Is there a way to do this with formulas
or if not how do I do it with code?