+ Reply to Thread
Results 1 to 2 of 2

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

  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.

  2. #2
    Registered User
    Join Date
    03-17-2022
    Location
    Los Angeles, CA
    MS-Off Ver
    2016
    Posts
    1

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

    There's not enough information here. From where do you get the number of hours each teacher teaches each subject? And what does "1şA" mean?

+ Reply to Thread

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