Adding lag to multiple tasks

M

MarkN

Hello,

I have an existing task list that needs 2 days lag added to many of the
tasks. Is there an easy way of doing this. Task durations are different in
most cases. Any suggestions would be appreciated.
 
G

Gérard Ducouret

Hello Mark,
Do you mean that the sucessor has to wait 2 days after the end of its
predecessor?
If so, try the link : 10FS+2d (if the predecessor is on the row # 10)

Hope this helps,

Gérard Ducouret
 
M

MarkN

Hi Gérard,

I was hoping that there was an easy way to add the same amount of lag to
several tasks (of differing durations) so that I don't have to do them one at
a time.
--
Thanks,
MarkN


Gérard Ducouret said:
Hello Mark,
Do you mean that the sucessor has to wait 2 days after the end of its
predecessor?
If so, try the link : 10FS+2d (if the predecessor is on the row # 10)

Hope this helps,

Gérard Ducouret
 
J

John

MarkN said:
Hi Gérard,

I was hoping that there was an easy way to add the same amount of lag to
several tasks (of differing durations) so that I don't have to do them one at
a time.
Mark,
It can be done but it will require a VBA macro to do it. Other than
that, I'm afraid it is a manual one-at-at-time operation.

The problem is not that the tasks have different durations, but that the
tasks have different IDs - so there is no way to use a simple "fill
down" operation.

John
Project MVP
 
J

John

MarkN said:
Hi John,

Thanks for that, code it is then.

MarkN,
You're welcome. Not everyone knows or is comfortable with VBA but it
sounds like it will be routine for you.
John
Project MVP
 

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