Struggling to create an externship work schedule for approximately 12 students. Three separate companies are offering the students Monday through Saturday hours, each company has multiple locations (up to 8) and varying times slots over a 12 week period.
Need to list all available dates and time slots at each location in such a way that the student’s name can be added to that particular location, date and time slot.
In addition each student will need their individual schedule so the individual student sheet will need to be linked to the “master sheet/s”. Each individual student sheet must capture their actual schedules, number of hours worked and the hours worked at the externship totaled.
I started by creating one worksheet with different tabs for each company but the linkage got too cumbersome. Any thoughts of how I can make this horrible task simple and easy for a basic excel user? Any direction/suggestion gratefully received.
Need to list all available dates and time slots at each location in such a way that the student’s name can be added to that particular location, date and time slot.
In addition each student will need their individual schedule so the individual student sheet will need to be linked to the “master sheet/s”. Each individual student sheet must capture their actual schedules, number of hours worked and the hours worked at the externship totaled.
I started by creating one worksheet with different tabs for each company but the linkage got too cumbersome. Any thoughts of how I can make this horrible task simple and easy for a basic excel user? Any direction/suggestion gratefully received.
