Forum Discussion
Formulas
Is there a formula I can use to compare tables on different sheets to track things like student jobs in the classroom. To keep track of how many times a student has a job to make sure every student h...
Riny_van_Eekelen You helped me with a spreadsheet to keep track of my student jobs. Now I need to make one that will keep track of my students online activity while we are distance teaching but also pull that information into 23 different spreadsheets that I can share with parents. How do I do that?
kozy_12 Difficult to visualise what you want. If you collect all the data in one table with a column identifying the student, you could use a Pivot Table to create individual tabs for each student containing all of their activities. If you then want to send that information to the parents you could then, for example, print each tab to PDF and e-mail it to them.