Need help to solve Excel cell increment in formula.
I have excel containing formulas which I am using in different excel to put those formulas for each column.
Que: Two formulas have cell umber which is incrementing by row.
Change the “Write Cell” activity “Range” as per your need like “B”+Counter.ToString or C+Counter.ToString or D+Counter.ToString … columns
Please try this,
Put the formula in “b2” cell as if(ab1="",)
Use autofill range activity and give source range as “b2” and destination range as “b2:b100” for filling to 100 rows.
Refer the below link also
For dynamically find out the last row,
Read the excel sheet data in the datatable variable name dt.
And in auto fill activity give range as “b2:b” + dt.rows.count.tostring
@pari_patel awesome please mark my answer as solution and close the thread so it may be useful to others in the future.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.