In A1 on sheet2 put =sheet1!A1 and drag the formula down the column for as
many rows as you need.

"Rod" wrote in message
...
Hi
Happy New Year to all.
I need a code that each time I enter value in cell A1 of sheet1 should be
placed in column A of sheet2.. I mean if I enter values in sheet1!A1 one
after another it should be placed in sheet2!A1 and second value in
sheet2!A2
and so on.

thanks in advance.