I think the only thing I need to do is some minor formatting. I have updated the drop down lists with what I need.

I was hoping to use the Pivot Tables you made....... I guess now I'll have to figure out how to make them myself! Yikes. I'll give it a shot.

I'm hoping to have this done by tomorrow because my counterpart is still using the old spreadsheet and I need to get him off of that ASAP because the 2016 info will need to be added again into this spreadsheet.

I'm going to tackle a pivot table right now. I'm going to blow away Pivot 2 and re-create it so that it totals all the incidents.

So far Pivot 1 is working so I will leave that for now.