Copy data from multiple workbook to one workbook without opening multiple workbook

[jb]

Dear Helpers,

My school has 10 grades from 1 to 10. Each class has number of subjects and each subject is taught by one or more teachers.

Now, each teacher is teaching in different grades.

And he / she is maintaining attendance sheet of each class in one workbook. Say teacher A is teaching in 4 different grades - e.g grade 4,5,6 and 7.

So he will maintain one workbook with 4 worksheets for the 4 grades in which he is teaching.

Say teacher B is teaching in 5 different grades - e.g grade 3,4,5,6 and 7.

So he will maintain one workbook with 5 worksheets for the 5 grades in which he is teaching.

same way other teachers will also be having their own workbooks.

Now, each teacher is class teacher of any one grade. So he /she needs one workbook in which they need to maintain attendance of all the subjects of their respective class.

Say, teacher A is class teacher of grade 7. Grade 7 has 6 subjects in total.

So teacher A wants a grade 7 attendance workbook with 6 sheets containing attendance of 6 subjects which are to be fetched from attendance workbook of those teachers who are teaching in grade 7.

In above example, teacher A and teacher B is teaching in grade 7.

So attendance data from grade 7 worksheet of teacher A and attendance data from grade 7 worksheet of teacher B should be automatically copied in grade 7 attendance workbook.

Attaching teacher A workbook, teacher B workbook and grade_7 workbook as sample.

Please help.

 

[herofox]

hi .... must to move this Post to VBA Dep.
you can choose one site from Following :
How To Combine Multiple Workbooks Into One Master Workbook In Excel?
Can you get data from multiple Workbooks without opening each one?
How to Combine Multiple Excel Files into One Excel Workbook
Transfer Data Multiple Workbooks Master Workbook Automatically
vba to copy a specific worksheet from multiple workbooks without opening the workbook

 

[vletm]

jb
Why did You duplicate Your thread?

Copy data from sheets of different workbook in sheets of one workbook

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...

chandoo.org

... okay ... this is without opening - but that title could modify in original thread.
This thread is closed.