In Numbers on my Mac Book Air: I have a Numbers table listing students, divided into Columns where, in order, I have: Surname, First Name, Year, Classroom (so 4 columns). This is a table that lists all the students I see (I work in Student Services in a Primary School).
I've created another sheet where, as I see a student, I add the same details as above, but have an extra column where I add comments after seeing them. What I'm wondering is, can I add a formula to the "Surname" cells so that the other cells automatically fill in with First Name, Year, Classroom (this information taken from the first Sheet)?
