Another way to ask my question I suppose is can I write a formula
(preferably;not so hot on the VB) which will source and display the relevant
data in December and then cut the link so the December data persists, even if
an update is made after December 31st. Then in February it will look at the
same source which will have been updated, and record this result in an
adjacent column. I would like to end up with student name, result for
December, result for February in separate columns.

The reason I ask is because if a student sits the exam once and then sits a
repeat the old data is transferred to comment boxes for future reference and
so is not available to formulae as such.
regards
jc132568


"jc132568" wrote:

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