I am working on a grades input spreadsheet.
Consider 3 sheets:
- A list of assessments containing references, names, weighing etc.
- A list of students, with IDs etc.
- A table with student names in rows referred from sheet 2; assessment names in columns transposed from sheet 1.
Now my problem is that once grades are entered in 3, if sheets 1 or 2 are sorted, the values in sheet 3 do not match with headers anymore.
How can I make sure that sorting values in sheet 1 or 2 will keep values in sheet 3 associated with their respective headers?