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?