Results 1 to 2 of 2

[Google Sheets] How to relate teachers with subjects for courses

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    South America
    MS-Off Ver
    365
    Posts
    13

    Question [Google Sheets] How to relate teachers with subjects for courses

    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!
    Attached Files Attached Files
    Last edited by elmit; 01-14-2022 at 08:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  2. (Google App Scripts) Copy and paste value for all Google Sheets contained in one folder
    By bobbiekan in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-29-2021, 11:48 PM
  3. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  6. how to relate sheets sum (complicated)
    By sanji_thecook in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2011, 06:48 AM
  7. relate data from multiple sheets
    By collamack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2008, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1