Hi,

I've got a worksheet where a column has a pre-defined set of values(a
list). When one of those values is selected, i want to fill other cells
within that row with other values.



So for example, if in A2, 2 is selected from a drop down list, i want
to fill B2 with "NOT REQUIRED" and C2 with "Enter string here", and
allow the user to enter the string. I used an IF statement to achieve
this , but of course C2 cannot be altered!Any ideas from anyone?




--
naijaexcel