Is this posible to make? If someone know please help me
In cell A1 i have list data validation which gives me the names of some sheets (example A, B. C).
In cell B1 i wont to have another list data validation with sources =$A$1:$A$3 from sheet defined in cell A1.
It will look like this
when i choose A in cell A1, then in B1, i can choose values from source =$A$1:$A$3 in sheet A
when i choose B in cell A1, then in B1, i can choose values from source =$A$1:$A$3 in sheet B
when i choose C in cell A1, then in B1, i can choose values from source =$A$1:$A$3 in sheet C
Thank you very much
In cell A1 i have list data validation which gives me the names of some sheets (example A, B. C).
In cell B1 i wont to have another list data validation with sources =$A$1:$A$3 from sheet defined in cell A1.
It will look like this
when i choose A in cell A1, then in B1, i can choose values from source =$A$1:$A$3 in sheet A
when i choose B in cell A1, then in B1, i can choose values from source =$A$1:$A$3 in sheet B
when i choose C in cell A1, then in B1, i can choose values from source =$A$1:$A$3 in sheet C
Thank you very much