Hello,
I am trying to modify an existing 2010 Excel file that is used by our organization. The original file had some basic dependent validation list depending on the choices made by the users filling out the form. For example, if the user chooses a region in the 1st field, then the 2nd field would only show the cities from that region.
I was looking to modify the file in order for the user to be able to choose more than 1 region in the first field. I was able to find a VBA code to add to the worksheet to allow this. I also changed my validation list to include an array formula as it would simplify our file for the future and I suspect it would help resolve my problem.
My question/problem is the following: If the user chooses more than 1 region in the 1st field, than the dependant validation list in the 2nd field does not work anymore. I understand that this no longer work because there is now more than 1 choices that was made in the 1st field. How you I modify the data validation formula in the 2nd field to allow to check for more than 1 criteria. For example, if the user chooses 2 regions in the first field, than the cities of those 2 regions should be shown to the user to select in the 2nd field.
I have attached a sample file to illustrate my problem. Choices made by the user are in column D and E.
Thank you for your time.
Bookmarks