Looking to create a calendar in excel and auto-populate the content with specific fields I enter. Someone showed me how to create an excel gantt chart but I’m really looking for a calendar view instead of a series of columns with dates. I reviewed the original post on Auto-Populating Excel Calendar but was confused by the instructions. Can someone please help me to (1) create a calendar in excel and (2) show me how to populate the calendar with fields like (dept and project name) into the dates on the calendar? I have two dates that are important (a due date for the project and when that project will be published). Is there a way to have both dates show info otherwise the most important date will be the publish date?
Bookmarks