S
Sean
Hi,
I have a project with many tasks. Mostly the same people perform these
task. When I assign recourses (people) from a common resource pool to
each task I have to select each resource individually from the pool for
each task. As such 10 tasks and 5 people for each means that I have to
select 50 names which is time consuming.
I tried to record a macro but nothing is recorded. Does anyone know the
syntax to assign a resource to a task?
Ideally I would like to take the task names, recourses and hours from a
spreadsheet but I think that that will be too much to ask. Just in
case: For example Tasks in cells A2 to A11, Recourses in Cells B1 to
F1, hours for each resource for each task in range B2:F11.
Any assistance will be appreciated.
Regards.
Sean
I have a project with many tasks. Mostly the same people perform these
task. When I assign recourses (people) from a common resource pool to
each task I have to select each resource individually from the pool for
each task. As such 10 tasks and 5 people for each means that I have to
select 50 names which is time consuming.
I tried to record a macro but nothing is recorded. Does anyone know the
syntax to assign a resource to a task?
Ideally I would like to take the task names, recourses and hours from a
spreadsheet but I think that that will be too much to ask. Just in
case: For example Tasks in cells A2 to A11, Recourses in Cells B1 to
F1, hours for each resource for each task in range B2:F11.
Any assistance will be appreciated.
Regards.
Sean