N
naijaexcel
Hi,
I've got a worksheet where a column has a pre-defined set of values(
list). When one of those values is selected, i want to fill other cell
within that row with other values.
So for example, if in A2, 2 is selected from a drop down list, i wan
to fill B2 with "NOT REQUIRED" and C2 with "Enter string here", an
allow the user to enter the string. I used an IF statement to achiev
this , but of course C2 cannot be altered!Any ideas from anyone
I've got a worksheet where a column has a pre-defined set of values(
list). When one of those values is selected, i want to fill other cell
within that row with other values.
So for example, if in A2, 2 is selected from a drop down list, i wan
to fill B2 with "NOT REQUIRED" and C2 with "Enter string here", an
allow the user to enter the string. I used an IF statement to achiev
this , but of course C2 cannot be altered!Any ideas from anyone