Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

how to copy the resources from one project to another

6 replies [Last post]
kumar s
User offline. Last seen 8 years 25 weeks ago. Offline
Joined: 26 Jan 2010
Posts: 159
Dear Guys,   I have to copy the resources of one project to another. both the projects  have same activities only the duration and the time is  changed. so what is the best way to do it.   thanks in  advance       Regards,


kumar s
User offline. Last seen 8 years 25 weeks ago. Offline
Joined: 26 Jan 2010
Posts: 159

Dear All

thanks a lot for all your inputs..

@ russel

since i have around 500 activities i have to change the duration for all the activites and there are around 50 milestones with constraints.

so if i copy the first project and keep on changing the dates time it will take more time...which i wanted to avoid.


finally i got it done this way

since both the project are same only difference in time and duration.

first i exported both the projects to spreadsheet with the reosurces/budgeted units/time /activities column

then i copied the resources assignment form the first which has reosurces assigned and pasted in the 2nd project where i have to copy the resorces. then i copied the budgeted units/time also.

by this i got the resources assigned to the 2nd project with the same budgeted units/time.

then i imported the 2nd project to p6. i had got all the resources asigned to each and every activities without changing the time and duration.this took me just 5 minutes.


hope this is also a good option...



Russel Carandang
User offline. Last seen 9 years 36 weeks ago. Offline
Joined: 5 Aug 2010
Posts: 5

hi kumar,

If you have the same activity and only difference is the duration and start date. why make it hard for yourself. Make a copy of your 1st project and you just have to change the Project name, duration and start date. that easy and that quick.


Roberto Jr Bustos
User offline. Last seen 15 weeks 6 days ago. Offline
Joined: 14 May 2001
Posts: 30

i think raymund's way is the simpliest way .  make a copy of the project with resources then revise the duration.

its easier to revise durations of activities than reassign all resources and quantities again.


if you will do it with import/export, the number of rows between the two projects wont be matching since the other one doesnt have resources assigned yet.

Raymund de Laza
User offline. Last seen 24 min 9 sec ago. Offline
Joined: 23 Nov 2009
Posts: 762

Hi Kumar,

The easiest way I know is to use a mirror of the project with resource loaded and revise the duration to suit your new requirements.

Apply the methodolgy as suggested by Primvera.


Hope this will help you.



kumar s
User offline. Last seen 8 years 25 weeks ago. Offline
Joined: 26 Jan 2010
Posts: 159

dear Daniel,

let me elaborate my query..

i have two projects which has the same no of activities.

only the activity duration and its start time is different.

 i have assigned the resources  for each activity in one project.

so i wnat to assign the same resources with same budgeted units/time to each of the activity.

now when i export to excel and try to copy the resources assignment from the one project to another it is not happening.

i mean the columns are not matching.

so is there any global change option to do this.

if we can do it in spread sheet can any body tell me the procedure to do it


thank s in adavnce



Daniel Limson
User offline. Last seen 4 years 47 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hi Kumar,

You can use Export and Import. You need to choose "Resource" when exporting.