View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dennis Cheung Dennis Cheung is offline
external usenet poster
 
Posts: 20
Default filter and relations between fields

in cell A2, user can select only A and B, i know how to do this.
if A is selected in cell A2, i need only aa, ab, ac can be seclect in cell A3,
if B is selected in cell A2, i need only ba, bb, bc can be seclect in cell A3.

can someone tell me how can do this?
--
Dennis Cheung