How to LINK data from one Google Sheet Workbook to another Google Sheet Workbook.
1. Open the Google Sheet Workbook, in this example, A Google Sheet Workbook of my school forms name as "School Forms and Grades TEMPLATE"
- ELECTRONIC CLASS RECORD FOR SENIOR HS
2. Make a copy of these two Wotkbook and save it on your own Google Drive Folder. I suggest that you use Google Shared Drive instead of Google Drive.
3. In School Forms and Grades TEMPLATE, Go to worksheet SF1 and start typing your students LRN in column B and NAMES in column C
4. Here, I want to import the LRN and NAMES located in column B and C of my Worksheet named "SF1". to other Google Sheet Workbook, in this example the Electronic Class Record renamed as "G11_1STSEM_SUBJ1"
5. Copy the URL (Uniform Resource Locator) of the School Forms and Grades TEMPLATE where the SF1 Worksheet is included.
7. Now create another worksheet and name it as INPUT DATA and create the formula as shown below. Type it on the first number for your student. Make sure that the column and rows in School Forms and Grades TEMPLATE will match with your columns and rows here.