Recording one cell entry

[mustafaal]

Hi dear

I would appreciate if you could help me with this:

I have a lab that requires me to record data (X) in the cell A1.

using a formula i will use (X) to get (Y) in the cell B1.

when I change the value of (X) in A1. i want the new value of (Y) to be recorded in B2, B3, B4..... for each new value of A1.

Many thanks

 

[JoeMo]

Why not put the new values of X in A2, A3, ... and the formula in B1 into B2, B3 ...?

 

[mustafaal]

I wanted to simplify my explanation. however i am trying to make a platform which contain many equations. so each time i add a measurement i want the results to be recorded somewhere else . this will help me to plot a graph

thanks