Sample 3: Collating of Data Using a Pivot Table and Macro

For My Driving Instructor

Download: https://drive.google.com/file/d/0B1pEq2dN7H9AWi1qNHdBY2J1QVk/view?usp=sharing

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’.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s