Hi my question are....
in cell A1 i type a number
that number should show up in cell (lets say c2)
When I type another number in A1 that number should show up in cell c3 and
so on.....

(the number in cell A1 is based on a calculation of several cells and will
change in a function of that calculation...)
The only thing I need answer on is: how to copy the current value of A1 over
to C1
and the new value of A1 into C2 and so on........