Hi everyone,
I’m a teacher and the online testing system we have outputs test results as a an .xlsx file.
The first sheet is an overview of information about each student and how many points they got for each task.
It looks a bit like this:
The following sheets are each named for a student and contain information about individual responses.
It looks a bit like this:
What I need to do is copy specific cells from the individual student sheets into the main list, but because there are a LOT of students, I need to automate this process somehow. Can I use the names from the List sheet as reference for the sheet names and then just give the cell numbers in question? Or is there some other trick to automate this process?
Any help would be appreciated.
Karl
it’s definitely not the way to go on the long run.