I am a primary PE teacher. I am attempting to set up a template to automatically set up class lists, attendance lists and options they have chosen.
I begin with a table of all students; names, class, year level, DOB, etc. Currently I sort by, for example, class, then I will cut and paste this class into a new sheet. I would like to make this an automatic step so that when I receive the list, the spreadsheet will automatically produce the class list in a separate sheet for me, with all the data listed above.
I think once I know the formula/step that I need to achieve this, I can repeat this for a range of other filters that I need to run.
I have attempted Vlookup and HLookup but I couldn't get them to work.
Any assistance would be appreciated.