Hi to all!
I have attached the spreadsheet I'm having problem with. forum.ozgrid.com/index.php?attachment/71963/
The Database sheet will contain around 7000 rows of data which will be extracted from 70 other workbooks.
What I wish to do is: fill the Name column of the different classes 'sheets from the data in the Database sheet automatically. The criteria for matching the names is with their forms (cell H3). I've tried to use Index with Match but in vain.
Also, the Average formula is not displaying a value. Note that not all subject columns will be filled in at any time.
Any help will be most appreciated.