I have a list of customers (about a thousand of them), and each of the customers has one of twenty area codes. I have created a dropdown list of the area codes. Now I would like to have another dropdown list, that lists all of the customers related to the area code indicated by the first dropdown selection.
The customers are listed on a sheet, the column A indicates the customer and column B the area code. I was thinking that the best way to do this would be to link a macro to the first dropdown list, and the macro would copy all of the customers from that area to a configuration sheet, where the second dropdown list would pick the values from. The macro should also check whether the customer already appears on the configuration sheet, since some customers appears on multiple rows (I have also some other information linked to the customer).
I don’t know if this is the best solution, neither how to create such a macro. Any help is highly appreciated! Thanks in advance.
The customers are listed on a sheet, the column A indicates the customer and column B the area code. I was thinking that the best way to do this would be to link a macro to the first dropdown list, and the macro would copy all of the customers from that area to a configuration sheet, where the second dropdown list would pick the values from. The macro should also check whether the customer already appears on the configuration sheet, since some customers appears on multiple rows (I have also some other information linked to the customer).
I don’t know if this is the best solution, neither how to create such a macro. Any help is highly appreciated! Thanks in advance.
