not exactly... I mean if I have 20 numbers(say) first time I enter first
value in Sheet1!A1 that should be placed in Sheet2!A1 and next time I enter
the second value in Sheet1!A1 that should be placed in Sheet2!A2 and so
on.........

thanks for response


"Tyro" wrote:

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.