How to Copy Progress Updates from one Project to another

You need to open the project with updates.

Export the activity updates in Excel.

Choose “Activities” and Click on “Next”.

Check on “Modify” options then “Next”.

Make sure that these columns are the selected options then “OK”.

Choose the file location and click on “Next”.

Click on “Finish” to export the spreadsheet file.

Do the same for the other project without the updates to Vlookup for updates.
Open the two Excel sheets to copy the updates.

Start to Vlookup at the baseline sheet with the “Activity Status”.
=VLOOKUP(Activity ID , choose the Lookup Array from the other sheet , 2 , FALSE)
Then, drag the equation to the whole column.

Vlookup for the “Actual Start” at the baseline sheet.
=VLOOKUP(Activity ID, choose the Lookup Array from the other sheet , 4 , FALSE)
Then, drag the equation to the whole column.

Vlookup for the “Actual Finish” at the baseline sheet.
=VLOOKUP(Activity ID, choose the Lookup Array from the other sheet , 5, FALSE)
Then, drag the equation to the whole column.

Vlookup for the “Activity % complete” at the baseline sheet.
=VLOOKUP(Activity ID, choose the Lookup Array from the other sheet , 6, FALSE)
Then, drag the equation to the whole column.

Then, make a filter to delete all the activities with 0 % Complete.

FREE COURSE

Primavera Online Basic Course -English

Online Primavera P6 Course for Engineers & Construction Managers Learn how to use Oracle Primavera P6 to plan, schedule, monitor, and control…

• 5,400 students
• WhatsApp support group
• Certificate

Start free

Delete all the rows with 0 % Complete.

You will find the updated activities only.

Copy the whole sheet and paste it as a “Values” to remove all the equations and Formulas.

The last step in Excel is to convert “Text to Column” from “Data” then “Next”.

Choose “Comma” in “Delimiters” and “Text qualifier” then click on “Next”.

Choose “Text” and “Finish”.

The Excel sheet is ready to be imported to Primavera.

Open the Primavera baseline schedule to import the updated activities.
Choose “spreadsheet – ( XLSX)” and “Next”.

Choose the file and click on “Next”.

Check on “Activities” and click on “Next”.

Choose the project to import the sheet and “Next”.

“Finish” is the last step to import the updates.

The updated activities in Primavera P6.

You may be interested in articles like this:
1. How to copy activity codes from one project to another
2. How to Save Layout in Primavera P6
3. How to Filter Delayed Activities in Primavera

Download the Resources of this Article

How to Copy Progress Updates from one Project to another 1.35 MB 2383 downloads

This File is included in the following course(s)

Basic Planning Course, Intermediate

---

Keep in Touch

Join our Email Newsletters and receive FREE weekly useful content!

Your Name

Email

---

Related posts:

Calculate Duration in P6 based on scope Understanding Merge Hotspot, Diverge Hotspot, and Logic Hotspot in Project Scheduling How to connect Primavera P6 to Power BI (Full Guide) How to add page numbers in Primavera P6 Schedule Cost Management for Engineers-Cost Terms