Excel: Dynamic links and cell reference

An issue with Excel is that you are not able to generate links that can dynamically increase, say I want to collate the final mark of every student (e.g. 100 of them) from a list of spreadsheets that they have saved. One way to do this is to have them save according to their class index number. If the class size is 100, we will have 100 files named 1.xlsx to 100.xlsx. However, in order to collate the result, it will be tedious as you will have to open up manually and record their marks. You can create a new … Continue reading Excel: Dynamic links and cell reference