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.

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 PDF Version of this Article to share with your colleagues