Hello,
I have a very complex schedule that I would like to set up in excel. We have aprox. 100 classes per week, the time slots for these classes vary, as do the instructors and classes for these time slots. I set up how I want the schedule to look, but I am seriously struggling with how to pull in the class graphics into the schedule. I have a data sheet that contains every class with the instructor and time slot on one sheet, and another sheet that contains every class with its' appropriate graphic. We have aprox. 25 logos that correspond with the 100 classes. And perhaps I have to do it all in a different way.
I would love to understand how I could set up a "master class" data sheet, and have the information pull into the schedule with the graphic intake.
Any help would be greatly appreciated.
I have a very complex schedule that I would like to set up in excel. We have aprox. 100 classes per week, the time slots for these classes vary, as do the instructors and classes for these time slots. I set up how I want the schedule to look, but I am seriously struggling with how to pull in the class graphics into the schedule. I have a data sheet that contains every class with the instructor and time slot on one sheet, and another sheet that contains every class with its' appropriate graphic. We have aprox. 25 logos that correspond with the 100 classes. And perhaps I have to do it all in a different way.
I would love to understand how I could set up a "master class" data sheet, and have the information pull into the schedule with the graphic intake.
Any help would be greatly appreciated.
