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:
Bookmarks