-
dependent dropdown list
I have this sheet named "DATA". In this sheet, in column G is the data that I want to consolidate in drop-down lists. These are subdivided by Countries, for example France contains the Cities from row 2 to 6 (Lyon,Paris,Bordeaux,Toulouse,Toulon) so that would be a consolidated dropdown list, so on with the following countries (there are quite a few countries with their respective cities in their respective columns).
IMG 1: Check the link: https://ibb.co/LZst89F
What I need is for the macro to create those dropdown lists in the next "List" sheet in column E (City column) based on what I put in the column D (Country column). For example, if I write Denmark in column D, in the next column E, same row, the macro would place the drop-down list that corresponds to it according to the DATA sheet (Copenhagen,Odense,Aalborg). I would need this to happen for any Country I put in column D based on the Data sheet.
IMG 2: Check the link: https://ibb.co/sv2sP12
-
-
It seems to me that the only way to execute this task is through a macro since the amount of data that I have in the countries can be infinite.
-
Large, maybe, but not infinite... Good luck trying to implement and maintain that in code.
-
1 Attachment(s)
Maybe have a play with something like the attached?
