Change value of cells in a column based on latest month's non-zero value

[vx7g3]

Hi,

I would really appreciate it if anyone can help me.

I would like to change the value of cells in a column based on the latest month's non-zero value.

In the attached sheet, the cells in column named VALUE must change values based on the latest months non zero figures, ie. they should automatically change value to match figures of October, since october is the latest month with non-zero values. When November values get filled, then the Value column must automatically change to reflect values of November since November column has the latest non-zero values.