Dear Mr. Dilli,

Thank you for your advice. Replacing formula in one row is possible as per your method. But my requirement is to change all the formulas.

Say Column 14 contains $P14*$L14
But Column 15 contains $P15*$L15
But Column 16 contains $P16*$L16

Hope I had clarified by problem. By the way could you suggest anything for formula change ?

Thanks
R.Vadivelan
velu130486@gmail.com