Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Add Predecessor to Multiple Tasks

2 replies [Last post]
Thu, 2017-11-16 13:47
Rob Garbutt
User offline. Last seen 6 years 39 weeks ago. Offline
Joined: 2 Aug 2017
Posts: 6
Groups: None

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??!!

Top

Replies

Fri, 2017-11-17 14:41
#1
Rob Garbutt
User offline. Last seen 6 years 39 weeks ago. Offline
Joined: 2 Aug 2017
Posts: 6
Groups: None

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

Top
Thu, 2017-11-16 17:42
#2
Tom Boyle
User offline. Last seen 3 weeks 5 days ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

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.

Top