Project description
TranslatedOffering extra earnings. I encountered a problem in building an automated work schedule for employees.
I have schedules for each project and a list with a general schedule of work.
The task in the overall schedule is: "Automatic search and setting of employee dates"
Date should be set according to three indicators Employee Name Stage of work Project name
That is, prescribing these three parameters, I would like excel to automatically find this employee with this task on the project sheet and this date is duplicated in the overall schedule of projects in the desired cell.
This would save me from manually searching and putting dates when a particular employee starts and finishes a particular stage of work.
Tell me if it's realistic to do that.
The file is also attached, if you can help with this I would be very grateful.