I need an excel spreadsheet completed so that I can quickly and easily see the below outlined reports.
? I ahve the workinsg of the spreadsheet completed, however I am open to suggestions from experienced excel people to recommending changes.
## v? ? ? ? 7 Groups
v? ? ? ? **Subjects; Provision for 20 subjects to be able to be changed**
v? ? ? ? **Subjects to be linked to Teacher**
v? ? ? ? **Running Total on each subject and each teacher**
v? ? ? ? **Running Total for each group for each subject**
v? ? ? ? **Running total for each room**
Please see attached mock up of what I was capable of doing. I require more advanced formulas written and reports to be created.