Hello Everybody,

I have a worksheet which is attached and I have all of the information from student detentions on the second sheet. When a student serves their detention, I put the date in column g. When I do that, I would like that student's info for that detention to move to a different sheet. I have next to no VBA experience and have pieced together the little that is in the document. Any help you could provide would be great.

Detentions New Workbook 002.xlsm