Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nick nick is offline
external usenet poster
 
Posts: 192
Default Data Validation

I have 4 columns and i have a drop down list in One column with 4 options but
i would like if they change the option that the next four columns change to
that option they chose? ex. If i have Concrete In column C and they choose
Concrete out of the 4 options i want to values in Column D, Column E, and
Column F all in the same row to change to the value that equals Concrete?
Anyone can help?