Forum Discussion
How to copy and paste exception days - MS PRoject
Hello, I have been using MS project for quite some time now and never figured out how to copy and paste exception days from one calendar to another. Here is my issue I work in the construc...
kmoreau48 --
You are going at this wrong. Take an existing project that has all of the calendars. Click File > Info > Organizer > Calendars. Copy the calendars from the right side of the dialog (in the open project) to the left side of the dialog (to your Global.mpt file). The next time you create a new blank project, all of the calendars will be available.
Also, when you create a custom calendar, it is easiest to copy an existing calendar that has all of your company holidays. And when you create holidays on a calendar, make the holiday recur in the range of 5-10 years to minimize your work.
In addition, you might want to take a look at a couple of my YouTube videos about calendars in Microsoft Project. They are:
https://youtu.be/GrR8v1Y4RN0
https://youtu.be/UOCuJdC9Oqc
https://youtu.be/XHKpEuZRixY
https://youtu.be/msZA6AyTKzM
Hope this helps.
You are going at this wrong. Take an existing project that has all of the calendars. Click File > Info > Organizer > Calendars. Copy the calendars from the right side of the dialog (in the open project) to the left side of the dialog (to your Global.mpt file). The next time you create a new blank project, all of the calendars will be available.
Also, when you create a custom calendar, it is easiest to copy an existing calendar that has all of your company holidays. And when you create holidays on a calendar, make the holiday recur in the range of 5-10 years to minimize your work.
In addition, you might want to take a look at a couple of my YouTube videos about calendars in Microsoft Project. They are:
https://youtu.be/GrR8v1Y4RN0
https://youtu.be/UOCuJdC9Oqc
https://youtu.be/XHKpEuZRixY
https://youtu.be/msZA6AyTKzM
Hope this helps.
Thank you for the quick reply, I have learned some features I wasn't aware of in MS project.
I was aware I could set up one custom calendar and then copy that one in order to modify the holidays only once. However, I still need to change the working time of each calendar and this can't be copy paste either. So I still have the same issue where I need to change data manually for every single calendar every single year.
For a 8 hours shift, it's easy since there is only the lunch to consider in the schedule.
But for a day with two 10 hours shift, it becomes more tedious to edit the schedule of the calendar (even though I don't have to change the holidays)
So I was always wondering which one is less work? changing the holidays for each calendar or changing the working schedule for each calendar?
After watching your YouTube videos I thought to myself maybe now it is easier to change the schedule since I can use a rule for the holidays and it will be repeated every year. But then Good Friday and Easter Monday are both dependant on Easter Sunday which in turn does not have a clear rule. Additionally, there are the "Observed" holidays as you explained in one of your video that I need to figure out.
In conclusion, I am still not sure which method is less work after learning those new features. I might have a little less Holidays to change but I still need to change the schedule for 17 calendars.
A simple copy and paste feature would make this task so much faster for both the Holidays and the working schedule.
- kmoreau48 --
Yup, copy and paste would make your job easier, but that feature is not available in the Microsoft Project desktop application. Sorry, but thanks for your long nice response to my solution.
