Forum Discussion
Multiple Dropdowns Help
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.
4 Replies
See the attached version. I used a macro to expand the definition of the named ranges from row 67 to row 68.
- 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.
Here it is:
- Thank you. I appreciate it!
