Assigning users to tasks in Excel

[muhammet.sezer2 (Muhammet Sezer)]

Hello, I have a daily task list that I run every morning. The number of tasks we need to do each day varies. Some days there may be 3 different tasks, some days there may be 7, some days there may be 10 different tasks. This number varies. I want to record the personnel who will perform the tasks in a table. I want to assign them. Below I share sample images as introduction and exit.
Day 1 :

Day 2 :

Day 3 :

[Anil_G (Anil Gorthi)]

@muhammet.sezer2

Add a new column as needed to maindt

Then use for each row in datatable/excel on maindt

And inside loop use assign with currentrow("Personnel") = personaldt.Rows(currentindex mod personaldt.Rowcount)(0).ToString

Cheers

[muhammet.sezer2 (Muhammet Sezer)]

Hi Anil,
I couldn’t understand you. Can you explain in more detail? Thank you.

[Anil_G (Anil Gorthi)]

@muhammet.sezer2

1. Read the personnel data into a datatable personaldt
2. Use excel file activity …and give the file path where to fill the data(main data with tasks)
3. Use a for eqch row in excel activity and give the range as Excel.Sheet("SheetName")
4. Inside loop use assign with above given formula

Cheers