I can use a Data valiation list to create drop down and teh value in the drop down is the value in Cell A1 by putting =A1 in the list in the datavalidtion screen
IF I change the value in A1, the data valdiation changes automatically
However I want to do it with 2 values and It doesn't seem to work.
I want the cell drop down to contain the value in Cell A1 and the value in cell A2
If I enter =A1,=A2 in the data validation list it fails.
Is this possible?
IF I change the value in A1, the data valdiation changes automatically
However I want to do it with 2 values and It doesn't seem to work.
I want the cell drop down to contain the value in Cell A1 and the value in cell A2
If I enter =A1,=A2 in the data validation list it fails.
Is this possible?