Saving cell contents to specific cell in another sheet based on value in list

Hi all,
I am trying to complete a comment generator for my students feedback - wb attached.

Sheet "CommentGenerator"
Student name in cell A1
Feedback in cell C1

Student names in destination sheet are in $A$2:$A$31 (named studentnames)

I need the contents of cell C1 to be copied to the appropriate cell in sheet "ClassComments" when a selection is made from the data validation list in C15 (as that is the last part of the comment) - based on the student name.

e.g. in the file student7 is selected, therefore the comment would be saved in B8 of "ClassComments"

Is this possible? If not, how can I program a button to do this?

Thanks in advance Luke

Hi, is this what you want?

That works perfectly! Is there any way to run the code you provided when a selection has been made in C15?

Please Login or Register  to view this content.

I've also tried to add to the code to copy C5, C6 and C7 into G2, H2, and I2 of class comments, but I can't solve it. Is there a glaring error in the code below:

Please Login or Register  to view this content.

what do you want to do with C15?

well done