Forum Discussion
Solved
Year View for Dynamic Calendar
Anyone able to assist with a yearly view for a dynamic calendar? I have a month view which pulls dates associated with a deployment from a table (I got this template from someone in the excel community). I figured I could just copy the month calendar 12 times and just change the months in the drop down but it isnt updating the dates and therefore, not pulling the deployment details. Attached is the file. The first table in the year view sheet is working as that was the same table I copied from the month view sheet. All other table do not work.
See the attached version. It's not the most elegant, but it should work.
That template is just not designed to be used as you intend. It's full with named ranges and named formulas. For example two of them that are used very often are referring to the values in B3 and C3. Then there are also named formulas that calculate day and month numbers based on the named ranges mentioned before. Just copying the January calendar will not work. You'll need begin by discecting the template first to get a thorough understanding of how it works. Then adjust all affected formulas in the copied/pasted calendars. That's quite some work.
Screenshots don't allow us to experiment.
Could you attach a copy of the workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Apologies, I thought it was attached to my other post. It is attached here.
See the attached version. It's not the most elegant, but it should work.
