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:

Create Dynamic Dropdown Menus in Google Sheets

Google Sheets is a great tool for tracking and entering data. The Validation command allows us to create a dropdown menu for people to choose from, which helps with consitency. But what if you don't know what the choices are going to be?

By using the UNIQUE function, you can create dropdown menus that automatically updated based on what users are entering. That way, our users can choose items based on previous entries or add a new item that will automatically update our list.