Hi I am a bit rusty with Excel so need some help
I have temp teachers that go to different schools on different dates.
I have a rota that has on the date running across the top and schools down the sides, inputted in the cells show the initials of the person who will be at what school on what date. This is the way it's always been done so that I can see an overall picture of it.
Is there a way to show on another sheet alike a pivot table to populate from their initial what schools and dates they will be attending? So it's clearer for the teachers and to provide this as a rota?
Many many thanks for help in advance!
I have temp teachers that go to different schools on different dates.
I have a rota that has on the date running across the top and schools down the sides, inputted in the cells show the initials of the person who will be at what school on what date. This is the way it's always been done so that I can see an overall picture of it.
Is there a way to show on another sheet alike a pivot table to populate from their initial what schools and dates they will be attending? So it's clearer for the teachers and to provide this as a rota?
Many many thanks for help in advance!