Breakup Projects in Master File

[Hadi]

Hello Experts,

i would like to know if there is a macro i can use to breakup about 300
invidual projects inside one big consolidated (static) file.

i know i can copy and paste each individually into new files but that can
take forever. is there a VBA code outhere that i can use?

help is always appreciated

 

[John]

Hello Experts,

i would like to know if there is a macro i can use to breakup about 300
invidual projects inside one big consolidated (static) file.

i know i can copy and paste each individually into new files but that can
take forever. is there a VBA code outhere that i can use?

help is always appreciated

Hadi,
I doubt there is a macro already written to do what you want - for a
couple of reasons. First, if it is a statically consolidated master, it
must have been consolidated from the individual subprojects in the first
place, so why not just use those. Second, if the static master has been
edited, the macro would have to be customized to define the criteria as
to what constitutes each of the "individual" subprojects.

A macro could certainly be written but it might be simple or it might be
complex depending on the structure of the file it is supposed to break
up.

Rather than do a manual copy and paste, it might be easier to save
multiple copies of the master under different names, (that's what you
are going to have in the end anyway), and then delete parts that aren't
needed. If this process is done iteratively, it will be easier and
easier. Granted, it is still a lot of work if you need to break the
master into 300 individual files, but it's that, or write some code.

John
Project MVP

 

[annbklyn]

I have the same problem, i'm trying to create a master project plan of all
the projects of 2006 which involves multiple clients and within each client
there are multiple jobs. I'm trying to find the best report that represents
how the project is doing for each Client and how many hrs are put in for each
resource assigned.

We want to show the client what are the completed & uncompleted projects of
this year and how many resources needed. Overall, we do not want to print a
report that shows all the clients we want to have a separate report for each
client.

Is this possible?

Thanks,
Ann

 

[DavidC]

Hi,

Try using a custom text field to identify the client against each task. Use
this to filter for each client. Alternatively (and possibly quicker) is to
out the tasks for a particular client under a summary task called 'the name
of the relvant client'.

The first option is likely to give you more flexibility in developing
specifc reports and views using filters for each client.

Hope this helps

regards

DavidC

 

[John]

I have the same problem, i'm trying to create a master project plan of all
the projects of 2006 which involves multiple clients and within each client
there are multiple jobs. I'm trying to find the best report that represents
how the project is doing for each Client and how many hrs are put in for each
resource assigned.

We want to show the client what are the completed & uncompleted projects of
this year and how many resources needed. Overall, we do not want to print a
report that shows all the clients we want to have a separate report for each
client.

Is this possible?

Thanks,
Ann

Ann,
Well, I think your issue is different from Hadi's. Hadi needs to break
up a master file, it sounds like you need to create one.

It also looks like DavidC has provided a couple of viable approaches. If
you have further questions, please let us know.

John