Import Data from One Spreadsheet to Another

With every new intake of trainers, the question always comes up about how to move data from one spreadsheet to another. For example, I have a sheet with information on grade 7, 8, 9 students in a master list, but I only want the Grade 7 student list to be available to the Grade 7 teachers.

ImportRange is one of the amazing functions available to us in Google Sheets. Think of it as a live import - always updating itself as the master sheet gets updated. You can't make any changes to the data (i.e., read-only), but you can still apply filters to the data.

Here's a video on how to use the ImportRange function to setup this process: