Hi guys I work in a school and they asked me to tell them which
students got the total full mark in all subjects, my problem is every
subject have its own excel workbook file, the students are sorted by
class then by IDs, from subject to subject the file may be different (I
tried referencing and it didn't work as expected) like some grades may
not take a particular subject this means that this subject file will
have a missing rows so I thought I could make a macro to do the
following:
- check the ID of the student
- get the total marks in all workbooks for that student depending on ID
and add them together
- copy the students with total full mark to a new workbook
- loop until it finish all the students IDs
I am not that good in excel VBA but do you think this could be done
using macro or am I going the wrong path?

note: I thought about using the search for ID approach instead of just
using cell offset because they are going to use the macro with
different files later on that may be a complete mess and the ID is the
only thing we can relay on.

You can start here
http://www.rondebruin.nl/copy3.htm

There is a example that use AutoFilter
Maybe you can use that

See: Copy Filter results from each workbook



--

Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message
ps.com...
Hi guys I work in a school and they asked me to tell them which
students got the total full mark in all subjects, my problem is every
subject have its own excel workbook file, the students are sorted by
class then by IDs, from subject to subject the file may be different (I
tried referencing and it didn't work as expected) like some grades may
not take a particular subject this means that this subject file will
have a missing rows so I thought I could make a macro to do the
following:
- check the ID of the student
- get the total marks in all workbooks for that student depending on ID
and add them together
- copy the students with total full mark to a new workbook
- loop until it finish all the students IDs
I am not that good in excel VBA but do you think this could be done
using macro or am I going the wrong path?

note: I thought about using the search for ID approach instead of just
using cell offset because they are going to use the macro with
different files later on that may be a complete mess and the ID is the
only thing we can relay on.