none
changes to successors RRS feed

  • Question

  • Hello,

    I have been given a schedule which has say 20 RFI tasks. So, task 1 is RFI1, task 2 is RFI2 and so on.

    These tasks are to be linked to 20 "RFI answered" tasks. RFI1 task is linked RFI1 answered task by Fs+20d. Is there an easier way by which I can link RFI tasks to RFI2 answered tasks in the same way as I have linked RFI1 to RFI1 answered?

    Can I set up a Macro or a formula which can do it?

    Wednesday, November 20, 2013 5:02 AM

All replies

  • Hi, You could create a macro to do this, based upon the relative position of the tasks to each other.  Worth recording a macro for one predecessor, and then running this for each non-summary task in the plan.  If you are new to macros and VBA this might take you some time though.

    Ben Howard [MVP] <a href="http://www.applepark.co.uk/ben-howard-blog/">blog</a> | <a href="http://www.applepark.co.uk">web</a>

    Wednesday, November 20, 2013 7:31 AM
    Moderator
  • Bhadkamar,

    Yeah you could write a macro but for 20 tasks it will take longer to write the code, even for someone experienced with Project VBA, than it would be to manually set up the links.

    Depending on the file structure, it could take less than a minute to set up all 20 links. As an example I set up a mock file with a series of RFI tasks and RFI answered tasks in sequence (i.e. RFI1, RFI1 answered, RFI2, RFI2 answered, etc.). I manually set the predecessor for the first set as 1FS+20d. I then set a flag field (Flag1) for all the RFI answered tasks and did a fill down of the Predecessor field. I then manually edited the ID in each Predecessor as required. When the filter is removed, all the tasks are linked.

    Just a thought.

    John

    Wednesday, November 20, 2013 3:20 PM