Forum Discussion
linking dropdowns from different tables.
Morning, it appears I may have posted this in the wrong section this morning so I am reposting here...hopefully the correct place. I am hoping someone can tell me if this is possible. ...
Yes and no. Dropdowns will refresh dynamically but MUST BE spreadsheet ranges !! In your example, you MUST create a range "Dropdown2" somewhere which auto-populates with the cities Charles has been too and then your second data validation (=Dropdown2) will list only those.