values are appearing automatically in the next column
 

we have a worksheet in which we copy the contents of other cell. for example
b1 copies the contents of a1, b2 a2, so on. But if we need the value of a3 to
appear in c3 it automaticaly appears also in b3! It is automaticaly copying
the contents of one cell automaticaly in the row until de column where the
cell that we need the contents to appear.