Hi,

as usual, I have a question from one of my Blog readers.

“Dear Nenad,
Today it’s real tough for me to manage my projects (2010)
hope you’ll find the solution for my head break
1. my question is weather i can share the resources between multiple projects
2. If do,can i get the resource tasks (i.e. pending tasks, completed tasks and ongoing tasks) of all projects in a single sheet of particular resource.
Please provide me the solution in your window it will be so help full.
Best regards,”

With a little effort You can have all data in one place. First, I will create Resource Pool in MS PROJECT 2013.

Now I will save this File with name ResPool!

Now, I am going to create three Project with four Tasks for each project, and I will assign different Resource per each Task. I’ll show you that only for Project #1, because there is the same Procedure for other Projects:

and:

and then:

So I will have Three Project and they will look like this:

Project #1

Project #2

Project #3

Project #4

I will save them, as you can see:

Now suppose that Task 1 of Project #1 is done 100%, Task 1 of Project #2 is done 75%, Task 1 of Project #3 is done 5o%, and Task 1 of Project #4 is done 25%. I will show this only at First Project (for the rest there is the same Procedure):

OK! I want to see all Task for all Resources for all Project in one view. I will use Resource Usage View in ResPool (Resource Pool):

But that is not what you want!!!! Of course it isn’t. Now I’ll modify this View by adding New Columns I need:

Much better now, isn’t it? Now I’m going to save Baseline for the First Project, and I will say that Task 2 is completed but it took 2 days more, and it started 2 days after planned:

and then:

and:

and I will get:

Back to the Resource Pool:

As you can see, Mary is over allocated now, and you can see difference in Task 2 of Project #1 with Baseline Start and finish, and Actual Start and Finish.

To conclude, you can see a lot of information about your Resources, and their Tasks in Resource Pool. You just have to adjust Resource Usage View as you want.

Regards,