Auto-populate calendar using data list

I am trying to auto-populate an excel calendar using a large list of data. I found the following thread that seems to be along the lines of what I am looking for: http://www.excelforum.com/excel-gene...-purposes.html

However, when I try to use it the data doesn't seem to copy properly.

I don't understand why the calendar simply lists "Lesson" when I have "Course #, Time, Inst, Lesson" in the cell. Am I missing something?

I've attached my file so you can see what I'm talking about.

Never mind, I think I understand how it works. Will mark as "SOLVED."