Thread: data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
paulu paulu is offline
external usenet poster
 
Posts: 4
Default data validation

I have a cell in which a payment type is selected, eg "CREDIT CARD" or
"CHEQUE" and so on. What I want to from here is change the selection list in
another cell based on what is selected in the first. E.g. if "CREDIT CARD"
is selected then the list in the next cell is for card types. If "CHEQUE" is
selected then the list in the next cell is Bank Names.

Is this achievable?

Thanks in advance
--
paulu