I would like to know if what I want is possible without the use of a macro.
Let’s say we have a Calc file that consists of 2 sheets. In cell A1 of the second sheet I type the value ‘blue’.
Now I wonder if it possible to create a column COLOR in the first sheet in which I can type any color, but where it is also possible to select the value ‘blue’ (from the second sheet) by using a ‘drop down menu’ (arrow).
So for example in the first sheet in cell A2 I type ‘red’, in cell A3 I type ‘green’ and in cell A4 I use the drop down menu and select ‘blue’ (‘blue’ has to be the only value in the drop down menu).
Is this scenario possible?