Increment problem

F

Frank Lennon

I have a grade predictor using MS Excel and this works
well for the whole class. I now want to do this on an
individual student basis. My question, is there a way of
each time a value in a cell is updated it records that
update in a different cell (increments to the cell below
the last update). If this is possible I would then like to
create a chart of this information which would then give
me an indication of how well a student is
working/achieving over a period of time.

Any advice here would be very much appreciated.

Thanks in advance

Regards

Frank Lennon
 
A

AlfD

Hi!

Just a skeleton thought:

You might like to keep a running list of the superseded value
somewhere (e.g. on Sheet2) .

A VBA routine like this would do that:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target <> Range("A1") Then Exit Sub
x = Target.Value
With Worksheets("Sheet2")
n = .Range("Z1").Value
.Range("A" & n + 1).value = x
.Range("Z1").value = .Range("Z1").value + 1
End With
End Sub

It simply accepts a new value into A1 : Z1 keeps track of the ro
number for the running list on Sheet2 : column A on Sheet2 logs th
values as they change.

Al
 
J

James R-S

Use this type of formula for defining the series in the chart

=OFFSET(Sheet1!R1C4,1,0):OFFSET(Sheet1!R1C4,COUNTA(Sheet1!C4)-1,0)
=OFFSET(Sheet1!$D$1,1,0):OFFSET(Sheet1!$D$1,COUNTA(Sheet1!$D:$D)-1,0)

They assume that the first row contains the name of the student and that the
scores are directly below with no other data in the column.

James.
 
Top