Hello,

Currently im doing a program in spreadsheet. I need to bring the value in
each cell to next sheet. For information, i have enter value in 6 rows in
column 1 sheet 1 and i want the value copy to sheet 2 column 1 by
automatically. when i entered values in 6 rows in column 2 it should copy
same in sheet 2. What the VB code and the loops for that?

Please help me.

dave