auto populate weekly schedule from list

Hi- I'm trying to get MS Excel to auto populate a weekly schedule from a list of courses. One worksheet has the list (course #, course/section title, days, time, instructor, etc.) and the other worksheet is a weekly course schedule with the same information. I want to be able to add courses into the LIST and have them populate in the WEEK worksheet automatically. Additionally, I want to edit information in the LIST and have the WEEK make the corresponding changes automatically. Any ideas how to do this? See the attachment for an example that I did manually.
EXAMPLE LIST TO WEEK.docx

Thanks!

hi this may help you

Please Login or Register  to view this content.