Mar 08 2017 07:44 PM
I have a spreadsheet with student results, where each student has several grades for different assessment items.
I need to be able to produce reports for each individual student.
In the past I have used a Mail Merge for this, and also Excel VBA to produce PDF reports. Neither of these options work using Excel Online.
Is there any Office 365 tool that will allow me to generate reports based on a template from Excel Online data?
Sep 26 2018 06:15 AM
I would love this, too. This is very easily accomplished with Google Sheets.
Sep 26 2018 07:25 AM
I had such experience without using VBA. In that case, I need to copy a lot of worksheet (Template Report) and then use the class no for the vlookup to lookup student's result in their report.
Feb 20 2021 03:09 PM