hi,
not entirely sure what you are asking but if i understand....
if the worksheet is in the the same workbook then all you need to do is draw
the value of the first sheet into the second sheets(or some variation there
of...)
on sheet 2 enter(in any cell)
=sheet1!A1 'or the cell address desired.
sheet 2 will update as sheet1!A1.value changes.
you will need a formula for each of the 12 months.
edit to fit your data.
regards
FSt1


"Ken" wrote:

A row of 12 cells representing 12 months, all of which have an initial
value of zero. Each month a value is inserted into one cell, with the value
remaining as each month passes. There is another cell in a separate
worksheet into which I want to place the most recently entered value from
the 12 cell row, i.e. it will overwrite the previous value.

I've tried using 'if' statements and various formula listed in the Help
files but without success. Can anyone offer a solution please?