Hello,
I currently have a monthly list of tasks based on the month's work date (nth date from the last date of the previous month). Normally what I do is copy and paste this 12x to make the full year calendar, but it is a pain to manage whenever there are changes to the dates that need to be reflected in the future months, since I have to copy and paste individual rows into specific lines every month. Is there any way to create a yearly sheet that would automatically sync with changes made on the monthly list of tasks? Thank you.
I currently have a monthly list of tasks based on the month's work date (nth date from the last date of the previous month). Normally what I do is copy and paste this 12x to make the full year calendar, but it is a pain to manage whenever there are changes to the dates that need to be reflected in the future months, since I have to copy and paste individual rows into specific lines every month. Is there any way to create a yearly sheet that would automatically sync with changes made on the monthly list of tasks? Thank you.