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 6 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. 

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts