Forum Discussion
Find out the remaining work on a linked task in another file
- Nicolas,
I'm sorry you are having difficulty trying to decode my address. Take another look at what I provided, there is no "john.project". If and when you figure it out do NOT post it to this, or any other, forum.
John
John
Thanks for your answer.
I use "Microsoft Project Professional" 2019.
This is the "ghost" that you said that I want to use.
I would like to copy the "ghost" as a task and the report the remaining work.
The yellow tasks above are the task that I copy, but the remaining work (collum "travail restant) are not good. I want to report it there.
Thank's a lot.
Nicolas
Nicolas_JOURJON
I'm a little confused. Are you saying you copy the ghost task (row) and then create a new task by pasting the copied ghost task? If so, then that won't work. What you can do however, is to create a new task, then copy the Remaining Work field from the ghost task and paste it into the Remaining Work field of the newly created task as I did here.
But I have to ask, why are you going through this process (i.e. what is your end goal)?
John
I work on a the following project:
Waiting reminder:
Currently we work with two different schedules.
-A schedule A (RTP) on MS Project.
-A schedule B (Validation) on MS Project.
The input data are:
Master Planning Validation -> %Task progress (schedule B)
RTP -> Availability Milestones XXXX (schedule A)
The output data are:
RTP -> Milestones of the RTP schedule for validation. (schedule A)
Master Planning Validation -> The progress of validation tasks. (schedule B)
Constraints: The RTP (Schedule B) have no control over the progress of validation tasks.
Validation does not have control over RTP milestones.
Carrying out tests
In all the tests carried out, I simplified the files.
Only two milestones and two tasks, the goal being to make the files communicate together.
Create two schedules -> a RTP Schedule (A) and a Master Schedule (B) validation.
1/ Consolidate schedules:
Links are ok between schedules.
End dates are not ok and remaining work is not ok.
Note: external tasks are only useful to link tasks between different projects, but information is usable.
2/ Create two schedules and link the Master schedule with the task address in the RTP file.
Dates Start End Ok
Remaining work in not ok.
3/ Copy-pasted the tasks with Special Paste "Paste with Link".
A copy-paste of the tasks from the Master Planning in the RTP planning with special pasting "Pasted with link"
Remaining work is not reported in the RTP file.
The remaining work does not work.
The RTP file can modify the progress of the Master's tasks.
Today I don't have any solution / direction to look after.
Do you have any idea in with way I should work to have a good communication between the two file.
Thank's
Nicolas
Well, I did ask why and you certainly gave me a synopsis, so thank you for that although it does kinda make my head spin with all the back and forth between files.
You won't be able to automatically create the project A/project B interaction using any form of linking. Furthermore, linked structures in Project (inter-project, master/subproject, or paste links) are fragile and can easily develop corruption if not set up and maintained with rigorous discipline.
I do have a couple of ideas. The first is to create a static master instead of a dynamic master. To do that, first create a new blank file, then insert the RTP and Validation projects as subprojects but un-check the "link to project" option just below the file selection list in the Insert Project window. That will effectively copy both files into the master where you can edit, filter, group tasks as needed to get what you need. Although this may not be exactly what you want, if it looks promising, we can further develop the process to better meet your needs.
The other idea I offer is a process using VBA to integrate data from both files into whatever form you need.
Try the first idea and see how that works. Then we can go from there.
John
- Thank's a lot for your answer. The two files are very long (around 600 row each) and it's impossible to insert both project in only one. I have to try the VBA thing!! I learned it (long time ago) and hope I will find the way to write and insert it in the project.
Nicolas 😉
Hello,
I don't want to copy manually the row, but I want to be automatic.
Thank's
Nicolas