Hi,

let's say I have data on A1 to A5 (1;2;3;4;5)

I also have A10=A1

and: B10=2*A10+3 ; C10=B10*3 ; D10=C10+B10 ;

I then transcript the value of D10 in B1.
After, I put A10=A2 and I transcript the value of D10 in B2, etc.

- I could expand A10 toward A14 and the same thing with column B to D.
I could then make cells B1 to B5 equals to D10 to D14 but in my case I
can't because lines 11 and below are took by other things.

-I could write B1=(2*A1+3)*4 but if I change a formula, let's say
C10=exp(A10), I would have to manually compute a new formula for B1.

I know there's a way to do that automaticly, but I don't know how!

Exemple in: http://cjoint.com/?fqrGb3sMgY

Thank you very much,

Alexandre