This is an extended question of 1st For Each Row in a data table
As you may know from the previous post, to perform the task, I filtered the original datatable (namely DT1) into a new filtered datatable (namely DT2). In DT2, I used For Each Row activity. The problems I have now are to 1) input the current date under Column D (i.e. Completion date) in each filtered row, and 2) finally add the completion date into the original Excel file which was output to DT1.
To explain more clearly, referring to the picture in the previous post, D13 should be input as 13/8/2020 (i.e. current date) after the action in the first row is completed (or we may say D2 instead of D13 if we’re referring to the new filtered datatable). And after actions in all rows are completed, the cells in corresponding rows under Column D should have all been input 13/8/2020. Then, I need to add the completion date into the original Excel file which was output to DT1.
Please let me know if I haven’t explained it clearly… thank you.