Dynamic Calendars from Data in Cells

**bmasella** · 11-09-2011, 06:53 PM

Is there a way to take a worksheet that has a column of dates (column B for example) - Column C is a description of the Activity for the date...Below is an example...

10/11/11 Onsite - Thom
10/12/11 Onsite - Thom
10/15/11 Phone - Susan - 9am
10/22/11 Phone - Susan -9am
11/2/11 Onsite - Thom
11/3/11 Onsite - Thom
12/6/11 Onsite - Thom

And generate a single worksheet for each month that has the month laid out in grid form - Sunday thru Saturday and the Column C data is in the appropriate grid for the day it occurs. The calendars could be created already and the data is just inserted into them on the appropriate date somehow or perhaps the calendars could be built dynamically as well? (this is supposed to look like a full page calendar view below) The end result is I want to be able to print the worksheets and have a full page calendar with all of the activities for each day on it.

HTML Code:

**6StringJazzer** · 11-09-2011, 08:20 PM

Can one day have more than one activity?

**bmasella** · 11-09-2011, 08:23 PM

It could but they would all be in column C.... Not that they would have to be... I could have a second row with the same date and a different activity...I'm open to changing the format of the source data used to build the calendars.

**6StringJazzer** · 11-09-2011, 08:45 PM

Here is a one-month calendar. List your events on the Events sheet. Select month from the dropdown box and type in a year. This does not support more than one event in a day. If that is required then it's back to the drawing board.