A value typed in one cell needs also to be appeared in another cell

[Anuru]

Dear Experts,

Pls refer the attached excel work sheet.

My requirement is: values being typed in M31 and onwards to be also appeared in M11 and onwards without re typing them in M row.

B/regards

[Special-K]

Maybe

in M11
=IF(M31<>"",M31,"")
and copy down

[Anuru]

Hi K,

Thanks a lot for your kind response and solution. However, pls excuse me for my forgetfulness about not mentioning the below point.

In M11, I cannot put any formula as in some instances I need to type values directly in it. Values need to be typed directly in M11(checking out) and so on in case of "non-wash" garments, however, in case of "wash garments", the checking out is considered later(after wash).

This is the reason I have kept row M31 and so on for entering values after washing process. However, for cumulative "checking out" the values in M11 are considered, in that case I have to re type it in both M31 and M11. I need to avoid this "re-typing".

I am not sure that there is a solution as such....

B/regards..