Ok, let me sum up the only two questions I think I need at this point.



You let me know if you think I'm missing anything.

1) Why am I getting blanks in the Jurisdiction drop-down but not the Incident drop down?

2) Are there any specific issues I need to worry about when formatting the Pivot Table? i.e. Changing the fonts, colors, etc. Will they carry over as the Pivot Table changes? I will obviously do some testing but thought I would ask as well.

I really can't think of anything else at this point.

I can add investigators and know how to update the Pivot Table to reflect them.

The Pivot Tables do the calculations.

The Log tab can be sorted by any column.

The Data tab can be used to update the drop down lists.

I think you did a great job for me and now I will try to enhance this cosmetically and start adding in the investigators, wiping out the old data, etc.

This is addressed above. If you go to Data: Data Validation for each and look at the specified ranges, you will see why.

Up on your ribbon to the right, you will see Pivot Table Options with tabs for Options and Design there. Options will let you modify the data displayed. Design allows you to format how they are displayed. Use the canned formats under Design.

As I've use the Format as Table functionality here, there are lots of things you can do. Sorting or even filtering right on the data table. For example, click the filter doohickey for any one of the columns with dates. You can select specific months or years, or even filter by Last Quarter and Year to Date.