Forum Discussion
Pete_Blackwell
Jan 21, 2023Copper Contributor
Cascading / Multi-Dependent Dropdown Lists
Considerations: There are three (3) dropdown items to be used; entity, expense category & expense sub-category. There are about 20 categories and 40 sub-categories. No one entity has a...
HansVogelaar
Jan 21, 2023MVP
Set the source for the data validation validation in G2 to
=INDIRECT("Tbl_"&$F2)
And the source for the data validation drop down in H2 to
=INDIRECT("Tbl_"&$G2)
- Pete_BlackwellApr 05, 2023Copper ContributorThank you!