How to copy/sync task's % Work Complete value from one MPP to another MPP (with same tasks) for change/update in each separate task - VBA RRS feed

  • Question

  • I have two MPP Project files. Both have same structure/tasks etc. One MPP file is to be edited by users to change only % Work Complete column of the task which is assigned to that user and the other MPP is master file which must retain the updated % Work Complete column value for each task changed in first file i.e. the second MPP file (master file) will contain updated values of % Work Complete against each task.

    Is it possible through VBA script which can run every time user update's his specific (allocated to him) tasks? How will I restrict user to update only the % Work Complete and what VBA script can be used to update value for each specific task in Master file?
    Tuesday, November 5, 2019 10:57 AM