C
Continental Translations
In column A, I have different languages, such as English, Spanish etc...
These languages appear several times. In column B, I have another list of
languages. Now what I want to be able to do is, create a dropdown menu in a
new worksheet with all the languages in column A listed in this menu. Now,
when I choose a language from the dropdown menu, such as English, I want a
list of all the languages which appear in column B next to English. I'd like
these two appear in a dropdown menu too.
Does that make sense? It's kinda like two interactive dropdown menus, with
what is selected in the first one depends on what appears in the second one.
These languages appear several times. In column B, I have another list of
languages. Now what I want to be able to do is, create a dropdown menu in a
new worksheet with all the languages in column A listed in this menu. Now,
when I choose a language from the dropdown menu, such as English, I want a
list of all the languages which appear in column B next to English. I'd like
these two appear in a dropdown menu too.
Does that make sense? It's kinda like two interactive dropdown menus, with
what is selected in the first one depends on what appears in the second one.