Sorry to bump an old post but wondering if someone cold help a person at the deep end and think this post is quite close to what i'm looking for.
Basically I would like to create a sheet that displays the most recent report input from staff for a given aspect so can by synced to other packages we use in school (e.g. classcharts, etc)
Our current set-up involves having aspects e.g. Progress and then within them resultsets e.g. Progress Yr 10 1 much like the example given above.
What I am unsure about is can I now create a sheet which will always populate with the most recent resultset for a range of aspects or is this something will have to change manually each time?
Thanks you in advanced.