How to consolidate projects in Microsoft Project - Master and Sub Projects using MS Project 2016

[@niksprojects]

Let me know if you like this video and would like to see more of these tutorials and if so which topic. Also check out and pre-order my Project Management Master Class for a 75% discount for Pre-Orders at www.nikscourses.com

[@evanevans4263]

Taking a course in this, thanks for your support!

[@niksprojects]

@@evanevans4263 You are most welcome. Just curious, how did you find out about this channel / video?

[@evanevans4263]

I suscribed to PM videos.

[@Yappapotmuss4ever]

Pop

[@reshwatrumihaque3726]

Thank you so very much for such a simple and quick tutorial which helped me a lot to build a master project that has 56 subprojects. I appreciate your help.

[@briandd57]

Nik, quick and clear instructions! Great job!

[@niksprojects]

briandd57 hi appreciate your honest feedback

[@khanhhuynh8011]

Thank you. Is there a way to show the Gantt chart for each subproject in the master project?

[@LuisGarcia-mn4jg]

Very well explained! Thanks

[@niksprojects]

Thanks 🙏 appreciate the feedback and glad it helped

[@festusjohnson8610]

Your are wonderful. Thanks for the great work, simplified and well understood. Love this video and would love to see more of your tutorials both in MSP and P6.

[@niksprojects]

Thanks a lot

[@vineet11106]

Thank you very much

[@niksprojects]

You are welcome, thank you for watching

[@lywas.fauzie8483]

Thak for simply explanation, stright to the point... it means a lot for me

[@niksprojects]

Glad it was helpful!

[@dominicwest9077]

Can you link tasks to each other between sub projects?

[@niksprojects]

Yes you can

[@bettyannwilliams193]

Nik what would cause a project duration to change when it's inserted in a master schedule?

[@niksprojects]

The duration shouldn’t change in master project. Check in the master project that the tasks are set to auto schedule (not manually scheduled). The master project will reflect the longest duration from the su project.

[@bettyannwilliams193]

@@niksprojects Thank you for your response. I will check as you recommended.

[@anyname38]

Is this possible across different PCs / users i.e., via SharePoint files? I need multiple teams, updating their own Sub projects, to update the Master project.

[@niksprojects]

Yes as long as the subproject files are accessible for the main project this should work

[@anyname38]

@@niksprojects great! Thank you for your quick reply.

[@brendafrancis9474]

How do you link tasks between the master and sub project

[@niksprojects]

The task should be in one place and not in both master and sub. But let’s say if you have task M in master that is dependent on tasks s in sub project then open the master plan and it should show the subproject task as well and in the predecessor for task M add dependency for task s

[@premkistories]

Thank you for sharing, this saved lots of my time migrating all my sub projects into Master project. Let me know if you have any video for resource management in projects as i want to allocate the resources to each project and understand if we need any resources in future.

[@niksprojects]

Typically in most organizations I worked, the resource allocation is managed outside of MS Project and mostly in Excel. This way the leaders can share the sheet and is easier to update the % allocation by project by month and see who is allocated to which project and forecast of when they will be free. I can probably make a video and excel template of resource allocation sheet.

[@jessestraight6062]

How do I sort by Finish date in a master schedule? I need all the sub schedule items to blend so I can see/track what item is coming up next.

[@niksprojects]

Hi , don’t right click on the Finish date column header, instead just click the down arrow next to finish header and you should see on the pop up menu an option to sort

[@NikVilluri]

Is the connection broken if the files are moved?

[@ishmaelphoma977]

Hello NIks Projects could you please assist me with this here problem... When I open one the sub-project files and go to Resource Usage view it shows the file path instead of the file name in the Project column for all the unopened subproject files. How do I go on about resolving this?

[@johncarroll6910]

Great job!

[@niksprojects]

Thanks a lot and appreciate the feedback.

[@vijaypawar8523]

Is there a way or defined formula wherein each task can be assigned a weight based or work hours , so if I add weight of all task should total 100 percentage

[@niravniel561]

Hi, thanks for the video, how can I link resources between two subprojects ?

[@amitdoctor3677]

HI nik how do I get 48 hrs schedule look ahead in MSP

[@nazrisaidin]

Thank you Nik

[@niksprojects]

ahmad nazri saidin glad I can help

[@AJ-kx5hr]

Thanks Niks. Is there a way in which you can add a subproject that is located on SharePoint?

[@niksprojects]

Hi, My understanding is that as long as you can access the sharepoint you can link the subproject by linking it with the sharepoint URL. Let me know if you can map the network drive of that sharepoint in your computer and try to locate/open the subproject via the network drive (that is mapped to sharepoint)

[@AJ-kx5hr]

@@niksprojects Hi, thank you for this. Unfortunately I cannot open this via the network drive. Is there another way?

[@nelsonellis9767]

i have a master mpp, where there are multiple mpps linked to it. Now if someone makes any changes in the tasks or duration in any of the linked mpps, i would like the master mpp to notify me about the changes made, so that i can inspect the changes before it gets implemented in the master mpp. Would there be a way to receive such alerts or notifications? Thanks!!

[@niksprojects]

Hi Nelson, I am not aware of any notifications or alerts feature available in MS Project in general.

[@nelsonellis9767]

@@niksprojects Thanks anyways !!

[@niksprojects]

@@nelsonellis9767 You are welcome! If you are new to this channel consider subscribing, so that we can build this project management community together. I strive to post Project Management videos on a weekly basis.

[@cinthiajoannacontrerasrami3656]

Thanks! ❤

[@niksprojects]

You're welcome 😊

[@StudywithMe-wj2bd]

Thank you :)

[@vijaypawar8523]

Hi, Can you add few video on generating customized visual report, showcasing resource allocation and should be dynamic

[@niksprojects]

Vijay Pawar good suggestions, I will give it a try

[@kinjalkumartailor279]

Very helpful Nik. I need your suggestion with this problem: I have 3 Project managers(Working on 3 projects each, total 9 projects) with MS project standard product on their personal laptop. As a program Manager I want to link all those 9 Projects to my master projects on my laptop. what will be the better solution to link all those projects on seperate computers ? Can do that using Sharepoint?

[@niksprojects]

Correct, as long as all the individual project files and the master files are located in the same network drive or sharepoint the master should be able to load all the sub projects

[@kinjalkumartailor279]

@@niksprojects Moreover, on sharepoint Master Project file will reflect all changes made on individual project file, correct?

[@niksprojects]

Correct

[@777kins]

@@niksprojects awesome. Thank you very much. This is very helpful.

[@niksprojects]

Glad it helped, thanks for watching

[@MrZinduu]

Is it possible to consolidate Sub project tasks into Master Project and how does it work? INS sec 9 Aaa Bbb Sec 10 Aaa Bbb STR sec 9 Aaa Bbb Sec 10 Aaa Bbb

[@niksprojects]

Yes it is possible to consolidate the sub project tasks in to master project, that's shown in this video

[@MrZinduu]

@@niksprojects Maybe my explanation is not good enough. I see in this video, the entire subproject is getting inserted to the masters. But I just want fx. 10 out of 30 tasks from any subproject into my master and leave the rest 20 tasks - is that possible?

[@sarieeify]

hi does the sub projects and master projects need to be open for changes to be captured?

[@niksprojects]

I need to check, but as far as I remember it will get synced when you open the master project. For ex: if you just open 1 of the sub project make your changes and close it and open up master project later , you will see the changes made in the sub project in your master.

[@AshutoshMukherjee7]

thanks

[@niksprojects]

Welcome

[@kanchanaperera2586]

How to link sub project activity to master program activity & how to calculate master program progress considering sub project progress

[@niksprojects]

That is what I am showing through this video on how to link sub project to master project. Sorry If I didn't answer any specific question. Let me know what was missing and I can elaborate.

[@kanchanaperera2586]

@@niksprojectsThanks for your reply . I want to link one of sub project activity to other activity in master program. ex. Master program ID 125's predecessor to be sub project (Master program ID 126) activity ID 2 FS, How to do this ?

[@anandv.k.7238]

hi , can you please make a video on how to link, manage and track bigger plans with more than 1000 to 10000 tasks

[@terrablader]

can you train me?

[@niksprojects]

Are you looking for Microsoft project training or General Project Management training

[@terrablader]

@@niksprojects m$ project

[@niksprojects]

Shall we connect again