I have a datatable that contains values with projects current deadlines and people the projects are assigned to (this is an excel file for which data gets added on a daily basis, except for column C and D (my question here is about the bot filling in the values in column C):
Next, I have an excel file with names of employees and the sector.
The first name for sector “food” in the 2nd table is “John”. The bot should check all rows of datatable 1 and if there is one project where the current deadline - date of today > 25 days, then it should not fill in the name of John as his workload is to high. It should then check the same condition for Selma and so on (for the first 4 as the sector is “food”). In this example, the bot should fill in Paul (not Dirk as he already has a project with a deadline > 25 days away from today) because he is the second priority for sector “Drinks” and is available for work.