Jul 17 2022 09:32 AM
I'm trying to do something very simple, but I can't find "the answer". Asking for help in finding it.
Goal: Populate time phased Work into MS-Project assignments.
Setup:
In MS-Project: Assume that my MS-Project file has a number of simple tasks, say 100 tasks with their durations and dependencies. Let's assume no summary level tasks to keep it simple.
In Excel: I have a table with about 1000 rows, in which I have the UIDs of the tasks and the resources assigned to each task in columns at the left hand side. Then to the right I have 52 columns with the hours that each resource is going to spend on each task spread out by weeks.
I want to pull that assignment data (resources and time phased work) into MS-Project. Ideally I'd like to do that using a simple import map, but if I have to use VBA I'm ok with that, but hoping someone has already written the code. I've looked for this particular problem but I don't see it written up anywhere. Can someone point me to a post or provide a link to instructions for pulling in time-phased data at the assignment level like this?
Thanks
Jul 17 2022 01:07 PM
Jul 17 2022 03:09 PM
Jul 17 2022 05:24 PM