jb
Member
Dear Helpers,
I want to automatically fetch the data from multiple workbooks into one workbook.
Let me explain the scenario.
There are total 10 classes (subject to increase) of different grades in my school. Each class has to study different subjects and each subject may be taught by more than one teacher. Each teacher may be teaching in different grades.
Now, each teacher is maintain one excel workbook for attendance where he /she maintains attendance of various subject he/she is teaching in different grades.
Say for example, teacher AB is teaching MATHS in grade 6 and grade 7, then he will maintain 2 sheets in his workbook – one for each.
Now, each grade has a class teacher who needs to maintain attendance workbook for the class assigned to him/her. Say for example teacher AB is a class teacher of grade 6, then he needs to maintain attendance sheet of all the teachers teaching various subjects in grade 6.
That means, AB will keep attendance of MATHS subject in a worksheet called MATHS_6_AB in a workbook called AB.
This worksheet data required to be copied automatically in MATHS_6_AB worksheet of workbook GRADE_6.
Teachers will keep their workbook password protected so no one can edit. Class teachers will keep their class workbook password protected. This workbook can be viewed by others.
Class teacher need not to open the worksheet of subject teachers. Attendance must be automatically available in subject sheets of class workbook as and when subject teacher teaching in that class will update the attendance.
Attaching sample files for your reference.
I want to automatically fetch the data from multiple workbooks into one workbook.
Let me explain the scenario.
There are total 10 classes (subject to increase) of different grades in my school. Each class has to study different subjects and each subject may be taught by more than one teacher. Each teacher may be teaching in different grades.
Now, each teacher is maintain one excel workbook for attendance where he /she maintains attendance of various subject he/she is teaching in different grades.
Say for example, teacher AB is teaching MATHS in grade 6 and grade 7, then he will maintain 2 sheets in his workbook – one for each.
Now, each grade has a class teacher who needs to maintain attendance workbook for the class assigned to him/her. Say for example teacher AB is a class teacher of grade 6, then he needs to maintain attendance sheet of all the teachers teaching various subjects in grade 6.
That means, AB will keep attendance of MATHS subject in a worksheet called MATHS_6_AB in a workbook called AB.
This worksheet data required to be copied automatically in MATHS_6_AB worksheet of workbook GRADE_6.
Teachers will keep their workbook password protected so no one can edit. Class teachers will keep their class workbook password protected. This workbook can be viewed by others.
Class teacher need not to open the worksheet of subject teachers. Attendance must be automatically available in subject sheets of class workbook as and when subject teacher teaching in that class will update the attendance.
Attaching sample files for your reference.
Attachments

8.3 KB Views: 3

13.4 KB Views: 2