Dear All,

Column A to Z is 1 language.
Column AA to AZ is the same data in another language.

F12 is a combobox ( validation-LIST source = N12T12)
AF12 is the same combobox in another language ( validation-LIST source =
AN12AT12)
The values in source1 and source2 has the same contence and possition just a
translation.

When selecting value 2 in F12 ( source O12) I want AF12 be set to value 2
( source AO12).

HOW, if it is possible ?

Thanks,

Filip