I am trying to create my own gradebook spreadsheet because my school won't
let me load a commercial program other than the one they use. I find that it
is not adequate, so I'm making my own.
What I want to do is have information that I type on one worksheet update
automatically onto other sheets. I want to have one data entry page, then
have a student's scores transfer to his or her own page.
I find if I set up a hyperlink, it takes me to that information rather than
allowing me to enter new data.
I know I can also type in "=" and then reference the original cell, but this
is very tedious to several times for 60+ students.
Is there a faster way to do this?