Guest
is there a way to use an old schedule just by moving all dates forward on a task list
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Yes,
But not just by one click
1) Highlight the Start date Column At the top.
2) Right Mouse Click.
3) Copy
4) Open Excel
5) Paste Special - Values (the contents into a excel column)
6) In the coulmn next to the figures assuming the first cell is A1 type "=A1+x" where x is the number of days you want to move the project forward.
7) copy this new cell down the column until you are at the bottom of the dates
8) Highlight the new dates
9) Copy them
10) paste them back into the start date column in MSP.
Hey Presto !
Any Probs let me know.
Rgrds
AB
But not just by one click
1) Highlight the Start date Column At the top.
2) Right Mouse Click.
3) Copy
4) Open Excel
5) Paste Special - Values (the contents into a excel column)
6) In the coulmn next to the figures assuming the first cell is A1 type "=A1+x" where x is the number of days you want to move the project forward.
7) copy this new cell down the column until you are at the bottom of the dates
8) Highlight the new dates
9) Copy them
10) paste them back into the start date column in MSP.
Hey Presto !
Any Probs let me know.
Rgrds
AB
- Status
Similar threads
- Locked
- Question
- Locked
- Question