HI @Sam_H
!) Use Read Range activity | Store it as DtRead
-
Use For each row in Data Table activity
-
Inside the for each row Use Assign activity
Currentrow(ColumnIndex) = "Vaildate"
- Outside the For Each row in DataTable Use Write range activity
Regards
Gokul