is there a way of having a data validation list that’s dependant on the users choice of another,
to elaborate
cell B3 is a data validation list, with the following contents, A, B, C etc
When A is selected, from that drop down list, C3 should display another list, with the following contents 1,2,3 etc,
However if B was chosen from the list in B3 then another list would ne displayed with the following contents Q,W,E, etc
thanks
to elaborate
cell B3 is a data validation list, with the following contents, A, B, C etc
When A is selected, from that drop down list, C3 should display another list, with the following contents 1,2,3 etc,
However if B was chosen from the list in B3 then another list would ne displayed with the following contents Q,W,E, etc
thanks