Hi Everyone!
I apologize in advance if this has already been asked, but I'm trying to make things easier for myself when it comes to my project schedule.



My project schedule isn't actually for one large scale project, but a series of site projects that have the same tasks, dependencies and durations (that are adjusted based on completion).

Right now, I have a single site template schedule that I will copy from and paste into the schedule that I actively use for all sites.

My problem is, it is PAINFULLY slow to paste into my active schedule due to its size and the number of times I have to paste (I'm already thinking of breaking my schedule into different parts). Example...today, I had to had 50+ sites to my schedule and it took about 4½ hours to get them all pasted.

And now for the question: Does anyone know how to write or know of any websites that teach you how to write the Macro in VBA so I can have it create that template right into my active schedule to include all tasks, predecessors and durations directly?

Thank you in advance!

ETA: I would like to write the macro myself, rather than record it because I have a bit of difficulty with the tasks that have multiple predecessors....plus it would help strengthen overall knowledge.

Hi
Hope this response is not too late.
I suggest you have a standard template project. Then have a Master Project document and insert a sub project for each subsequent project. You will be able to view all sub projects in the same file.
If you need further help then let me know.
Tony(OTPM)