external dependency management - automating the links

P

pipmonck

hi i am working on a large prog where we manage external dep manually,
this is done using text1 feild to create a unique text string in
project a, replicate it in project b , in text2 feild of the giving
project (a) states it as an O/P Dep the in the recieving project and I/
P Dep and then each week two mangers discuss dates movement and
realign the dates, works very well but... when there are 60 odd
projects & 50 PM's comms get a little forgotten...

We need to be able to link them all to run an impact analysis tool for
change and slippage across the whole programme, so i have created a
consolidated file and inserted all 60 odd projects, 46000 odd lines,

in a consolidation project where i have all the plans, there are 7500
O/P dependencies and 9000 are I/P dependencies, i want to write some
VBA code that will sort alphabetically a-z by text1 feild (unchecking
the outline and renumber boxes), and then sorting alphabetically z-a
by the Dep type(I/P & O/P) and then when finds two text1's the same
but text2 opposites O/P above I/P Link them, and then repeats through
all 46000 lines..... Manually its taken me three weeks to do it, and
soon we will have a major replan and i will have to do it all
again...

having this consolidation off line so to speak , by that i mean it is
not the live versions, allows me to control the external dep links so
that any movement is not automatically transferred to the next
dependent project, so no PM is upset by the movement outside of their
control, but what it does allow is that as the progress is made i can
save the revised project as the old name in my consolidation and it
automatically remember sthe external links...

but with the major replan going ahead soon it will be weeks before i
am able to replicate the process and that is why i need the code...

i have tried the record macro function but i can only use this with
manual lookup to see when the two texts 1 are same and text2
opposites, its too slow

any help would be appreciated

and if Rod Gill is reading this... i have ordered your book but its
not arrived yet...

The Happy Planner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top