How to updated pivot tables on different tabs from user form parameters?

[Bob Phillips]

I tried Oakland Schools, etc like you and got the same thing. I did mention to my project leader your recommendations and he replied with -
"We don't want to deslect the blank from the pivot tables because that is ensuring that we are working with the district summary record and not the building records which is what we want in this case.

That is not what I meant. What I was saying is that the charts are showing blank entries, which have no values. They are irrelevant, create a datapoint on the series, which obscures a little. Best to just filter it in the pivots.

On the EnrollmentByGrade pivot table the requirements are to show only the current school year in the graph so the school year is required."

Okay, but how does the current school year get selected, it isn't on the selection form?

Did you catch my last post about somehow automating the input of CSV files into this workbook and converting those 3 columns to 5 characters? I can't have the superintendent manually formatting these columns every time. You know that won't fly ;-)

I did respond to that in a separate thread as well, but I think I am still missing it.

Almost forgot, is there a way to change the display name on the summary page to match what was chosen? I didn't code that, but was curious.

Which display name are you referring to?