Add Predecessor to Multiple Tasks

R
Rob Garbutt 👤 Member for 8 years 10 months

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

R
Rob Garbutt 👤 Member for 8 years 10 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

T
Tom Boyle 👤 Member for 19 years 7 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.

Forum Sponsor

Top Posters

AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts
Peter Holroyd
51 posts
fridau
0 posts
Rahmat Hidayat
32 posts
pinoyplanner
1 posts