I have a dropdown list with 2 values. When I select one of the values I would like to change values in other cells. For example, The dropdown list has 'Front Nine' and 'Back Nine' as values. When I select one of these values I want to change cells on the same sheet to show appropriate information for back/front nine (hole numbers,pars). Can this be done?