Add Predecessor to Multiple Tasks

Member for

8 years 3 months

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

Member for

18 years 11 months

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.