I am using Excel as an educator to keep track of grades. Each sheet is the "rubric" for each assignment. The first two rows and first two columns are frozen panes (columns for grades, rows for student names/lab group numbers). The grades are also sortable by student name/ID number. Pretty simple so far.
My issue is that the students are constantly added to and removed from the course, or their lab numbers changed. I want to be able to change the lab number, add or remove a student on one sheet (presumably the first) and have it be changed across the entire workbook.
I have tried using "=Sheet1!A3", etc. to make the remaining sheets have the same name and lab number for all sheets, which worked at first. However, when I would sort the first sheet, the grades from the other sheets would not sort with the change, causing all of the grades to be incorrect for all other sheets.
I have attached a file with "dummy" students and grades, etc (pun intended). The names and group numbers were actually typed into this file (did not use "=Sheet1!A3").
I hope that this issue makes sense. Any help is greatly appreciated!
My issue is that the students are constantly added to and removed from the course, or their lab numbers changed. I want to be able to change the lab number, add or remove a student on one sheet (presumably the first) and have it be changed across the entire workbook.
I have tried using "=Sheet1!A3", etc. to make the remaining sheets have the same name and lab number for all sheets, which worked at first. However, when I would sort the first sheet, the grades from the other sheets would not sort with the change, causing all of the grades to be incorrect for all other sheets.
I have attached a file with "dummy" students and grades, etc (pun intended). The names and group numbers were actually typed into this file (did not use "=Sheet1!A3").
I hope that this issue makes sense. Any help is greatly appreciated!