Forum Discussion

Pckipling's avatar
Pckipling
Copper Contributor
Nov 01, 2022

Copying Relative Predecessors

Hi,

 

I have a large MS Project file and have several dozen themes within it that all have the same sequence of tasks (and relative dependencies) within them.

 

In the interest of time, I’m therefore copying the set of existing tasks and rewording for each theme.

 

When I do this- project copies the absolute predecessor for each task.  I’d like to know if there’s any way of copying/pasting and MS Project pasting the relative predecessor

 

e.g

 

task 1 
task 2 (predecessor task 1)

task 3 (predecessor task 2)

task 4 (predecessor task 3)

task 5 (predecessor task 4)

 

When I copy the above, the predecessors

remain static/absolute

 

e.g

 

task 6 
task 7 (predecessor task 1)

task 8 (predecessor task 2)

task 9 (predecessor task 3)

task 10 (predecessor task 4)

 

What I’d like to know is if project can paste relative predecessors

 

e.g

 

task 6 
task 7 (predecessor task 6)

task 8 (predecessor task 7)

task 9 (predecessor task 8)

task 10 (predecessor task 9)

 

Any help gratefully appreciated!


Thanks,

9 Replies

  • Hi Pckipling 

    If the link destination tasks are previously created, I think there is no direct option for what you are looking for.

     

    Maybe with some trick that someone comes up with.

    Mine is this (see attached image):

     

    1. Copy the block of original rows in which the link pattern to be replicated is repeated.
    2. Paste in the first row of the destination block.
    3. Copy the new cells from the predecessor column,
    4. Select undo.
    5. Paste into the first cell of the predecessor column of the destination block

     

    Note.- You must also include in the original block the tasks that are predecessors of any of them, even if the predecessors cell is blank.

     

    I hope I have explained it well and that it is useful to you.

    Ignacio

     

    • markb380's avatar
      markb380
      Copper Contributor

      Thanks Ignacio, That is probably as quick as a get around solution I think I'm going to get. Much appreciated.Ignacio_Martin 

  • John-project's avatar
    John-project
    Silver Contributor

    Pckipling 

    What version of Project are you using?

    How exactly are you doing the copy/paste?

    In this example I created two simple tasks with a standard finish-to-start relationship. I then copied the complete row of the first two tasks and pasted them twice. Links were automatically updated.

    John

    • Pckipling's avatar
      Pckipling
      Copper Contributor
      Thanks John- I’m using MS Project 2013

      Copying the entire row does help actually and seems to update some of the predecessors as I need (I was only copying certain fields and not the whole row).

      However, I’m still finding that any tasks with a lag or a constraint date retain the original predecessor?
      • Pckipling's avatar
        Pckipling
        Copper Contributor
        In fact, on further investigation it’s not just where there is a lag or constraint date attached to the task- Project seems to update some predecessors and retain the original predecessor for other tasks and appears random?

Resources