I have been asked to put together a dashboard to track training and costs. I'm fairly OK with using OFFSET to gather data for scrolling lists, etc and using the camera for graphic snapshots, but how on earth do I gather the data across 10 managers, each with up to 25 staff who may attend an unknown no. of courses to show that to my senior manager?
I was thinking of a worksheet per manager, and some of the courses will be common across the departments, but what's the best way to drag all of that together? I can see one sheet to aggregate the costs, but beyond that' I'm kind of struggling.
Any ideas most welcome :)