I'm not sure if there is an easy way to do this, but I have a spreadsheet with dates, times, events and locations, etc. listed and was wondering if there was an easy way to create a calendar from the information... ie parse the data and fill in the calendar blocks with the event information according the date field of the spreadsheet. Hope that makes sense.

I have a similar question and was wandering if you got help. I have two spreadsheet in which one is a calendar that I created. In the other spreadsheet is my source data in which I am trying to populate the calendar spreadsheet with events from the source data spreadsheet. I used =IF(Calendar!$K$23='2009 (2)'!U3,INDEX('2009 (2)'!A3,MATCH('2009 (2)'!U:U,'2009 (2)'!A3,'2009 (2)'!U3))&" - "&'2009 (2)'!C3&" - "&'2009 (2)'!R3)

to get the data formatted as I want it displayed on the calendar. the problems is that the data is populating in the wrong cells. how do i tell excel to only populate the fields with the source date that is a match to to date?