View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aditya Aditya is offline
external usenet poster
 
Posts: 54
Default conditional dropdown

i want to make conditional dropdown like this

if a1="x" dropdown in a2 should be US,CANADA,MEXICO
if a1="y" dropdown in a2 should be CHINA,JAPAN,INDIA,KOREA


thank you in advance