Hi,
I am creating a Google Sheets with two sheets:
- Teachers: The teacher's names.
- Subjects: The subjects's names.
These sheets are separately because every year a teacher can be added/deleted. The same for subjects.
Now I want to produce a table whose rows are teachers and columns subjects. This table is for each course, for example "1şA", "3şB" etc. For this I created a sheet "Teachers & Subjects".
So for each table, I want to put in each cell an "x (n)" where x indicates that the teacher teachs that subject, and n means how many hours it teachs.
I used a dynamic table but I can't edit the cells, so I don't think this is the best approach, since I required a new sheet (Teachers & Subjects).
Why a dynamic table? Because I want to add or delete existing subjects.
I upload a workbook as an example, but this must be done in Google Sheets. How can we achieve this? Thanks!
Bookmarks