I have this problem here:
I have a list of 300 users of a site.
Each user has one department (200 departments in total) and one region (AND, BRZ, PER, RDP).
Each region has 50 departments.
I made a speedometer that shows the % of access on the site by region. I used a combo box + INDEX. Worked perfectly.
I wanted to improve and made a speedometer that shows the % of access by region and department. But I came across this problem:
I use two combo boxes (one with the region and one with the departments) + INDEX. But the 2nd box shows all 200 departments. Can I do something so that when I select a certain region in box 1 (BRZ for example), only the departments related to that region appear?
By data validation, I was able to use = INDIRECT to make this separation. But I need the "Cell Link" of the combo box to do the operations with INDEX.
Anyone know what I can do?
I have a list of 300 users of a site.
Each user has one department (200 departments in total) and one region (AND, BRZ, PER, RDP).
Each region has 50 departments.
I made a speedometer that shows the % of access on the site by region. I used a combo box + INDEX. Worked perfectly.
I wanted to improve and made a speedometer that shows the % of access by region and department. But I came across this problem:
I use two combo boxes (one with the region and one with the departments) + INDEX. But the 2nd box shows all 200 departments. Can I do something so that when I select a certain region in box 1 (BRZ for example), only the departments related to that region appear?
By data validation, I was able to use = INDIRECT to make this separation. But I need the "Cell Link" of the combo box to do the operations with INDEX.
Anyone know what I can do?