I'm trying / failing to find a way to create a way to autofill cells in a spreadsheet.
The spreadsheet will allow teachers to quickly tell an admin team to issue praise postcards to specific students with a custom message.
They need to enter: the student name, their department from a drop down list (sorted this already), student tutor code so the cards can be distributed and finally the message to the students.
To stop teachers having to find the tutor code for every student, I want to try and automate it so that when the student name is entered, the spreadsheet searches for the student name on another sheet, finds the tutor code and then populates the tutor code cell automatically.
Is this possible? If so, what's the name or description of the code I need to look in to?
Cheers
The spreadsheet will allow teachers to quickly tell an admin team to issue praise postcards to specific students with a custom message.
They need to enter: the student name, their department from a drop down list (sorted this already), student tutor code so the cards can be distributed and finally the message to the students.
To stop teachers having to find the tutor code for every student, I want to try and automate it so that when the student name is entered, the spreadsheet searches for the student name on another sheet, finds the tutor code and then populates the tutor code cell automatically.
Is this possible? If so, what's the name or description of the code I need to look in to?
Cheers
