Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and add numbers from many WBs depending on ID column
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells in a column depending on another column but excluding duplicates | Excel Discussion (Misc queries) | |||
How do I search for repeated numbers in same column | New Users to Excel | |||
Total numbers in column where the row cell matches the search crit | Excel Worksheet Functions | |||
Search for duplicate entries in a column of numbers | Excel Worksheet Functions | |||
Search and add numbers from many WBs depending on ID column | Excel Discussion (Misc queries) |