Dear Experts,
Can you set up excel to capture data at particular times?
Scenario:
University students sit exams and their results are recorded in excel. So
in December all will have a grade. By February these letter grades may have
changed due to resits, recounts, etc. To assist with the paper work I would
like excel to record the grade in December and then look again in February so
that I can say that for student A the grade was C (one column) and changed to
D(another column) for example.

regards
jc132568