In my excel file, I have a list of students and the test marks of their subject arranged according to the semester. Also in the same file but in a different sheet, I have a list of subjects arranged according to the individual student. What I want is when I update the marks in the semester section, the marks will also automatically update in the student section. And after the individual student section is updated, I would like to have a button in which when I click it it will generate an academic transcript. It will be much clearer when I show you the files I have now. Or you can also propose a template that fulfills the above conditions.
Copyright © 2020 | Truelancer.com