Auto Fill Range Dynamically

i have an excel contain 3 columns.

in Transaction Date Column have to fill Auto Fil based on the last row of that column.
exp–C8(16-Jan-22) have to fill remain rows.

Can any one help ?

AutoFill.xlsx (9.3 KB)


You mean want to increment day by day for each row in Transaction Date column ?

If yes then use Auto Fill Range activity and mention Source and Fill Range as below.

SourceRange: “C8”
FillRange: “C9:C20”

@Anand_Designer Some times the last row might change, For now it is 8th row , some times it could be some other row. If there is such scenario in your case please use the below workflow (10.3 KB)





this file will send by client, we dont know how many rows they filled for Trnsaction Date . some times they will give Data upto C10 or C15. based on last row , we have to auto fill.


Hope you know the last column name. If yes then follow below steps.

  1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then find the row count as below.

     rowCount = dtInput.Rows.Count
  3. Finally pass the FillRange as below.

1 Like

Thanks For given solution

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.