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?