Auto assigment of resources

Dear All,

 

I would like to kindly ask you to help me on below question

 

On Grant Chart I made up column where I have formula. According to this formula the column shows me how many person I need to complete the task till Deadline.

Is there any possibility to set up RULE, Function and etc. where MS Project will take numbers from this column (let's say Number10) and add resources to this task?

 

Thanks a lot in advance

Kindly



 







 

T
Tom Boyle 👤 Member for 19 years 8 months

Hi Ramil,

You could try some simple vba approach as Larry advised over on MPUG.  Alternately, you could try an approach involving uploading resource assignments from an Excel File.

I wouldn't be overly optimistic with either approach, as MSP seems to be designed from the ground up for manual entry of resource assignments using specific dialogs, with each dialog involving some background processes to interpret and condition your entries. You may need to adjust your automated entries/processes to match what MSP expects to see. 

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts