autopopulating dates from a list in excel into a calendar

[psychosammy]

Hi-
I am new to the forum and really need some assistance. I feel my excel skills are pretty good, but, this is stumping me for some reason. What I need is help on creating a calendar in excel that will autopopluate a list of meeting dates and holidays to the calendar. I am a school psychologist and I work in several schools. I have my meeting dates and student names in a spreadsheet, but would like that data to autofill into a calendar so I can keep track of meetings, etc. I just can't seem to figure it out and it is driving me crazy!

[BadlySpelledBuoy]

Quick question.... What calendar? One you've made in Excel? The one included in Outlook? One from a third party application?

Perhaps some example data (anonymised of course) and some details on the calendar you wish to use would aid a swift solution from someone for you.

BSB.

[psychosammy]

Hi- Thanks for the response. I would prefer to to populate in a calendar in excel. I use excel a lot. I am attaching a example of the list of student names and dates. I would also need a color code to distinguish the meeting dates that include an evaluation also Example.xlsx into a just plain old monthly box calendar with the month and year at the top with the days boxed below. Much like the generic template in excel. it would run the school year- august 2014 to may 2015

THANKS!

[hoyasaxa215]

If you've got specific times for meetings, this could help.