lukmana_sam
New Member
- Joined
- Oct 23, 2024
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Dear all,
I have a question about automation in excel.
In the "composition" sheet, I need to assign several projects (column E) to each employee (total 60 employees) according to the required number of employees in the "staff_need" sheet.
The projects will be valid for 3 working days, and on the 4th day, they must be reassigned randomly based on the applicable criteria.
Each project has employee criteria (see the "staff_need" sheet, column SKILL CRITERIA), for example, PROJECT_A requires employees with PBK or MULTI skills, and the required number is 0.31 or 1 person (if rounded up).
Thanks!
I have a question about automation in excel.
In the "composition" sheet, I need to assign several projects (column E) to each employee (total 60 employees) according to the required number of employees in the "staff_need" sheet.
The projects will be valid for 3 working days, and on the 4th day, they must be reassigned randomly based on the applicable criteria.
Each project has employee criteria (see the "staff_need" sheet, column SKILL CRITERIA), for example, PROJECT_A requires employees with PBK or MULTI skills, and the required number is 0.31 or 1 person (if rounded up).
Thanks!