Need code for rhe calculation part in I column
The calculation part of I4.
Is Total Amount given above -value in H4
ie). 160.57-6.41 = 154.16
Then calculation part for I 5 Column is
Value in I4-value in H5
ie) 154.16-6.41=147.75
Like I 5 Column calculation we need to do for remaining column.
For example:
Then calculation part for I 6 Column is
Value in I5-value in H6
ie) 146.75-6.41=141.34
same for remaining column I6-I20
Note: calculation should be done by bot should not used excel
read the value from C2 with read cell then do operation and write it in D2
then try to use read range activity and use range from A3, then use for reach row activity , inside the loop assign do the operation for every row value and update it at the same time
resultDataTable= yourDataTable.Clone() ' Create a new DataTable with the same structure as
' Add a new column "D" to store the subtraction results
resultDataTable.Columns.Add("D", GetType(Double))
' Perform the subtraction operation and populate the "D" column in the resultDataTable
For Each row As DataRow In yourDataTable.Rows
Dim newValue As Double =160.57 - CDbl(row("Value"))
resultDataTable.Rows.Add(row.ItemArray.Append(newValue).ToArray())
Next
