I want to make a drop-down list in CALC where the selection determines the selections available in a second drop-down.
Here is what I doing. have a list of cities, their corresponding counties, and then their corresponding municipalities. Then the list tells me what Ultiliy companies that location uses.
I want to select the city from a drop-down menu, then select the corresponding counties in that city, then have it fill in the municipality and utility companies to the right for those values
I have the drop-down menus on sheet 1 and all the information on sheet 2. Any help or guidance will be appreciated. I uploaded the file just in case anyone wants to see what exactly I am dealing with.
Utility Providers List for Michigan.ods- (33.73 KiB) Downloaded 40 times
Thank you in advance.
