Multiple Dropdowns Help

[catherine9910]

Hello Everyone,

I have attached the data of what I am needing help with. I have done multiple dropdowns, but not to this extent and I have run out of ideas. In the workbook on the Dashboard tab is what I am needing help with. You can edit this workbook as it is a copy and doesn't contain any actual company data. If you want to actually change the formulas or dropdowns, that is fine. I can just copy the formulas. Thank you all for your help. 

[#2]

@catherine9910 

See the attached version. I used a macro to expand the definition of the named ranges from row 67 to row 68.

[#3]

Thank you. I appreciate it!

[#4]

Ok so I was able to apply it to my original workbook. Now I would like for the YTD totals change with month. So, if there were 5 YTD incidents in March and we had 5 more in April. When you select March the YTD would equal 5 and when you select April it would say 10. I think right now my formula is showing total through the whole year not to date.

[#5]

@catherine9910 

Here it is: