Maintaining multiple Project files

[Todd Kay]

I have to maintain 8 separate project files to track the work of 8 different
employees. If I need to enter a task that is identical in all ways in each
of the 8 different files, is there a way to do it once and have it propagate
into all 8 files automatically? Currently I drag and drop into each file
after entering the task manually into the first file.

Thanks,
Todd

 

[John]

I have to maintain 8 separate project files to track the work of 8 different
employees. If I need to enter a task that is identical in all ways in each
of the 8 different files, is there a way to do it once and have it propagate
into all 8 files automatically? Currently I drag and drop into each file
after entering the task manually into the first file.

Thanks,
Todd

Todd,
First of all no two tasks are exactly identical, otherwise they would be
the same task. If nothing else the "identical tasks" are performed by
different resources at different times or in different places.

The simplest way to do what you want is to create a template file. Then
use that template to create each of the 8 files. However, if you need to
add a new task to an existing file then you either will have to copy and
paste as you have been doing or use a VBA macro to replicate the task.

John
Project MVP

 

[Todd Kay]

John,

You are correct, the same task is being performed by 8 different resources.

Given that the 8 files are already created and maintained daily by me, the
template file is not if use. Could you please explain the VBA macro, I
believe I have someone who can do that for me if you can give me some more
information.

Thanks,
Todd

 

[John]

John,

You are correct, the same task is being performed by 8 different resources.

Given that the 8 files are already created and maintained daily by me, the
template file is not if use. Could you please explain the VBA macro, I
believe I have someone who can do that for me if you can give me some more
information.

Thanks,
Todd

Todd,
Well one fairly "simple" way to use a VBA approach is to record a macro
while you copy the new task from one file and paste it into the next
file. Making the code work for all 8 files is then an extrapolation of
that recorded macro code.

A more automated macro could be written but I'm not sure it would be
worth the effort as I assume you don't do this process very often. If
you have to do it on a regular basis then before you have someone invest
more time in a more complex macro, I would examine your need for 8
separate files. There might be a more efficient way to meet your end
goal.

John
Project MVP