Hi. In calc, I have set the cell B1 to a dropdown list with the contents of a valid cell range $A$1:$A$2 (Data > Validity).
Say I have selected “001” (value of A1) for B1. When I go to cell A1 and change its value “001” to “X001”, the value of the cell B1 doesn’t change automatically. I would have to reselect the right value manually, this time “X001”.
Is there a way to get a validity dropdown list and have the value of B1 automatically updated if the value of A1 is changed?