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

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.

Originally Posted by NeedForExcel

October has all Zero Values, Sep has non zero values.. :O

Am I missing something?

Sorry I meant September which has non zero values and whenever October gets filled in then the Column VALUE should reflect that and so on and so forth for November and December

Thanks that works perfectly! Appreciate your help