Hi All,
I'm sure this is something that people on here are able to do, I just haven't been able to find anything after researching (maybe not using the right keywords).
Basically, I have to drop downs that are linked using "Data Validation". Based on the values that are selected I want to be able to show a list of associated roles based on the criteria selected. Presuming this would need to be done via VBA?
At the moment I have the lists, but the data isn't setup. I'm open to suggestions on how to model the data to best accomplish this.
Any help/direction would be greatly appreciated!
I'm sure this is something that people on here are able to do, I just haven't been able to find anything after researching (maybe not using the right keywords).
Basically, I have to drop downs that are linked using "Data Validation". Based on the values that are selected I want to be able to show a list of associated roles based on the criteria selected. Presuming this would need to be done via VBA?
At the moment I have the lists, but the data isn't setup. I'm open to suggestions on how to model the data to best accomplish this.
Any help/direction would be greatly appreciated!