Good afternoon!

I am working on creating a data collection and reporting tool for the teachers in a school that I currently work at. I have the data collection sheet formatted the way that I want it and have a reporting template that populates with student information, data, and graphics based on user input. The issues I am facing occur when I try to automate the report generation using VBA.
  • The code that I have so far does a fine job of opening a new workbook and creating a report for each student in the class period, but it is not automatically populating each new report with the correct information. As far as I can tell, the scores are transferring correctly, but the charts are not changing; they seem to all format to the last data that was pulled by the VBA code.
  • At this point, I can only generate the reports for a single class; I need it to generate reports for each class included in the workbook, and have each class of reports generated as a new workbook of its own.

There are two attachments: the "Data Attachment" contains the 3 class periods, the report template, and a formulas sheet to keep things tidy - pressing the Generate Student Reports button on the Reports worksheet triggers the VBA code to generate the reports; the "Report Attachment" contains the output file of the automatically generated reports. You can see that the scores change but the graphics do not.

Any help that anyone could provide would be greatly appreciated.

Joe

Data Attachment.xlsm
Report Attachment.xlsx