How to write a specific data from one Excel sheet to another sheet through script? -

please find below details,

input output 2   8 6   7 0   0 0   0 55  88 0   0 0   0 0   0 0   0 75  94 0   0 0   0 0   0 0   0 30  30 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 45  45 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 0   0 14  106 13  13 

i have above data in sheet1, want write data sum of each in column in sheet2.

are going add input(sheet 1) , output(sheet 1) , display result on column 1(sheet 2)? if so, try this;

private sub add()  dim integer  = 2  until sheet1.cells(i, 1) = ""         sheet2.cells(i, 1) = sheet1.cells(i, 1) + sheet1.cells(i, 2)  = + 1 loop  end sub 

i assumed input on column 1 , output on column 2.