Forum Discussion
Linking and sharing excel documents
Scross2020 This could be done by using a pivot table with a filter by student. Then you can create separate tables for each student in the blink of an eye.
If you could upload an example file with (anonymous) master data and the summary by student, I believe it can be made fairly easily.
Thank you very much for replying. I have attached two documents, one of the master marksheet where I would like to enter the data, the other is the student marksheet which I would like to share with the student. I would like this sheet to read from the master sheet but when sharing, not allow the student to change the data, only read it. I hope that makes sense.
Scross2020 Thanks for sharing this. Now that I see what you've created, my idea might not be what you had in mind. The attached workbook takes your data, but in a different structure. A summary is created in a pivot table, which in itself is not very useful. But from the Summary, the pivot tables per Student are created very easily. Perhaps you'll find inspiration in it.
Thank you very much for trying anyway. The system I have created does work but I have to input the data into each students file rather than one file. I did try it this way but it wouldnt update for the student unless I opened the file and re-saved it. I just cant figure it out.
I used to use Google Classroom and it worked brilliantly but now we are not allowed to use it anymore which is such a shame