Skip to content

Add Predecessor to Multiple Tasks

Rob GarbuttMember for 9 years 2 months
Created
2
2
0

Hi all, is there a way to add a single predecessor to multiple tasks? 

Surely I don't have to go through and add it one by one??!!

2 replies

Oldest first
  1. 0
    Tom Boyle ·

    As I answered a few minutes

    As I answered a few minutes ago on Stack Exchange:

    1. Organize/filter your schedule so that all 50 predecessors are located together.
    2. Add the Successors column to your task table.
    3. Enter the ID of the desired successor into the successors list of the first of the 50 predecessors.
    4. Select the cell you just entered, then use the autofill cursor (black square at lower right corner of cell) to pull the successor ID into each of the remaining 49 predecessors. (If predecessors are not adjacent, then use copy/paste, though you'll need to paste 49 times.)

    This won't work if your predecessors already have other successors and your intent is to add a new one. In that case dump the successors column to Excel, manipulate by concatenating strings, then copy/paste back to MSP.

  2. 0
    Rob Garbutt ·

    Of course, trusty Excel!That

    Of course, trusty Excel!

    That looks like the route I'll have to take since there are all manner of differing predecessrors on each task.  Thanks for your help!

    Rob

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?