Summary of Data

I have a little problem writing a Macro to summarising in some date. PSA sheet.

I have a sheet for data input, with my students' associated grade, timings and number of attempts relating to different tests they do in class.

I would like to extract all student information and update the archive tab after running the macro to save me copying and pasting 30 students' data.

Please note that the number of lessons will change depending on class, so the macro needs to run for each student from row 5 down until the first blank row. And the same until the next blank column.

I would also like the indicator that the archive is complete.

Really struggling here so please advise.

Oh sweet thank you! this is almost perfect. The last thing I want it to do is to ignore missing records. I.e. if I have a student who misses lesson 1, I don't want any lesson 1 data to be summarised. However if they come to lesson 2 and obtain a score, then I want that to be summarised. Is there a way of missing a record if there is missing information in the G column of the active row for a student?

Correct. Say that student 2 missed lesson 1, I don't want a record for that in my archive. Essentially is any incomplete data for a lesson, I don't want it to archive.