i shouldn't have told my boss that i can do Dependant drop down. Help!
I am trying to create in excel two dynamic drop down lists one depending on the other.
I have no problem in setting them up, however, i am having two problems right now:
when i go back deleted a first drop down cell, there is no error message, the dependent value remain;
i am able to type in anything i want in the dependant cell when i do not enter any values in the first drop down cells.
when cells are copied into the spreedsheet, the data validation doesn't work, nor when rows are deleted or added. how do i manage the reference?
i am using =OFFSET(INDIRECT(SUBSTITUTE($A2," ","")),0,0,COUNTA(INDIRECT(SUBSTITUTE($A2," ","")&"Col")),1)
and copied to the dependent column.
any experts?
i have not tried sorting yet.