For My Driving Instructor
I came across an interesting situation with my driving instructor. He was collating a list of all the lessons the instructors in his team had taught for the day and the result of the lesson, being a pass or fail.
He was collating this data by hand and I asked if I could help him. I don’t think he took me seriously, but here is the solution – dear instructor, this is for you if you happen across this site.
The spreadsheet uses a macro that automates the creation of a pivot table – with some basic VBA thrown in.
Remember to ‘Enable Macros’ when you open the file and press the button ‘Process Data’.