title: How to Identify Overlapping Resources in Multiple Projects - Microsoft Office
body: <p>My questions is as follows:</p>
  
  <p>Is there a way to make a master project plan incorporating multiple projects (not necessarily sub projects) in Microsoft office. As our resources get pushed around due to parts and items not arriving and shipping dates being moved forward amongst other things etc, sometimes the resource plan has to be changed regularly. I want to be able to pull all current projects into a master project plan so that I can identify where project resources are overlapping. Not necessarily by task but more by employee.</p>
  
  <p>To try and explain a bit better: </p>
  
  <p>Project 1:<br>
  Project Manager: John<br>
  Project Engineer: Jack. Task - Drawing</p>
  
  <p>John assigns Jack to work on a task in Project 1.</p>
  
  <p>Project 2:<br>
  Project Manager: Mark<br>
  Project Engineer: Jack. Task - Documentation</p>
  
  <p>Jack wasn't supposed to be working on Project 2 for a further 2 weeks but the deadline has been moved forward and Mark has also assigned Jack to work on a task on his project.</p>
  
  <p>I'd like to create a master project where I can pull in Project 1 and Project 2 and find a way for it to identify the resource overlap, regardless of the fact that Jack has been assigned to 2 different tasks, but more because he as an employee has been assigned to two projects at once.</p>
  
  <p>Is this possible?</p>
  
  <p>On a larger scale realistically I'll need this to incorporate about 6 Projects and about 20 staff members across, so I can find all the overlaps.</p>
  
  <p>I am aware that there is a way to split a person between 2 tasks by assigning a percentage that they will work on both, i.e 90% on task 1 and 10% on task 2 but obviously this won't be project exclusive and my aim is to identify the overlaps rather than create them on purpose for resource sharing.</p>