I have the following problem:
I need to make a report in 2 different languages.
Let's say I put the required texts for the 2 languages in a different colum in a worksheet (e.g. column A for English, column B for Dutch).
Is it possible to use a dropdown in another worksheet to select the correct language (reference to the correct column in the other worksheet)
So, in cell A1 I want to place a dropdown for language selection (EN or DU), in cells A3 to A10 I want to see the text in the correct language based on the other worksheet and corresponding to the language selected in the dropdown.
Is this possible?
Thanks.
Bookmarks