I have input file which contains details of materials
Sheet1 contains columns like OpenQty,ProdQty,SalesQty ,it has got 2194 rows ,at 2195 row they summed up all the quantities from all the cloumns , i need to get summed up qty for each column and write that to a cell in another sheet
you can use read row activity with the specified range to get the value from the parent sheet
and use write range or append range activity to write those values into your child sheet
@ShivuDundi - If you like to do this dynamically (at some part)
Assign LastRowNo = dt.rows.Count+1 → This will give you the value of 2195(Note: If any of the columns ends at different row #, this code will still max row # of any of the column. so if wont work )