If all my worksheet names are written dynamical ( I will not know the names of them) how can I build a "Totals" worksheet at the end and then calculate and average of data rows?
I have 100 students and their grades. Each worksheet is a separate series of exams given. At the end I want to write totals.
I have seen where people have used $worksheet = $excel->getSheetByName('Sheet 3'); but like I said I will not know the names. I have 6 different courses all with different exams.
Here is an example.
Worksheet #1 is named Cardiovascular Pathology.
Worksheet #2 is named Autonomic Pharmacology
Worksheet #3 is called CNS Infections
Worksheet #4 is my totals I want to write for each student.
If E is where I want to calculate my averages how do I write the equation and pull the info from each worksheet?