I created an answer sheet templete that would grade a test once you put in the student's answers. It looks like this
https://spreadsheets.google.com/spre...hl=en_US#gid=0
but imagine 12 sheets similar (but not exactly) to this (grades 1 - 12). Once I fill out the empty information, I just need to print it, not save it. There are multiple students I have to grade. So I inserted a macro that would clear the "student's answers" column quickly.
My boss wants me to collect the scores and names of the students as I grade them. How do I gather the name and scores of the students and put them in a different sheet automatically, when I basically delete their information once I clear their names using a macro? My original spreadsheet is more of a generator than data. What do I do?
I'm confused.
Bookmarks