Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

select Sheet2.A1:B4 and →insert→Names→create... from ..[x]top row

in Sheet1.A2 do →Data→Validity...Cellrange: $Sheet2.$A$1:$B$1 copy down in this Column

in Sheet1.B2 do →Data→Validity...Cellrange: INDIRECT(A2) copy down in this Column