Hello, I may be biting off more than I can chew here. I write reports and have been using an excel file to track my dates. Recently I've had to create a calendar within my tracking sheet to show level loading. I have to track 3 things in a calendar: date my draft is due, date my final report is due, and the 30 day old date for each report. I've used a quick macro to make calendar templates for each month that I then paste below my data. I also use formulas to calculate how old each report is, and when things are due based on the work week. So my sheet looks like my data in rows on top, with the calendar below it. All of the other columns on my sheet do not need to be tracked on the calendar.
I want to know, is it possible to create a calendar that will automatically pull the information from my columns (day 30 column, etc) and populate it into days of the calendar. I would like to learn how to make it so I can just fill in the single row for each report and have it appear in the calendar. The calendar and data sheet don't need to appear on the same sheet. I've attached the file for reference. Sheet 1 is the macro sheet; I just run the macro from the developer tab and copy the calendar that is created there. Sheet 2 is the data sheet.
Bookmarks