Dear all,
I was tasked to print off students' registers for our lecturers/tutors depending on the class room numbers (I attached a basic and illustrative excel worksheet for you to have a look at). So the crucial filter in my worksheets is 'Room' numbers (I coloured them so it is easier for you to see).
I applied 'filters' and I was able to filter data based on the Room numbers. I was then able to print off registers. The problem is that there are over 70 rooms/classrooms/lecture theatres. Last week, it took me 3 hours to print them all one-by-one. The printing was tedious and I lost the will to live. Every time I had to go into filters/ untick the existing filter/ tick a new one/ press ctrl + P and finally print off the pages one-by-one, Room number after room number
Is there any way I can print off my registers in one go so that I don't have go into ticking and unticking Room filters for each of the rooms? The attached worksheet is very basic. The worksheet that I use at work has nearly 1500 rows!!
Thank you all for your help - yet again... I don't have anyone to turn to and I am desperate to say the least.
Bookmarks