BenjaminDubai
New Member
- Joined
- May 7, 2007
- Messages
- 42
The overall problem. I would like to be able to manage my Projects Resources in Excel. Yet people like to see the task information in MS Project so I want to be able to move information back and forth.
This is fine, I paste the MS Project columns I want into one worksheet and then use the ID to VLOOKUP the information I need when I want to. HOWEVER I have hit a snag.
I want the ability to add a %, per resource, per task, per week.
e.g. Week 1, Resource 1, Task 1, 50%
Week 1, Resource 1, Task 2, 50%
As soon as I add this layer of complexitiy I become stumped and have to do a lot of manual work (ugggh) that will be difficult to maintain accuately.
Any idea how I can store and retrieve this information?
This is fine, I paste the MS Project columns I want into one worksheet and then use the ID to VLOOKUP the information I need when I want to. HOWEVER I have hit a snag.
I want the ability to add a %, per resource, per task, per week.
e.g. Week 1, Resource 1, Task 1, 50%
Week 1, Resource 1, Task 2, 50%
As soon as I add this layer of complexitiy I become stumped and have to do a lot of manual work (ugggh) that will be difficult to maintain accuately.
Any idea how I can store and retrieve this information?
