23,681 views
In today's video lesson, we will learn how to pull data from pages of other spreadsheets and treat them with the QUERY and IMPORTRANGE functions to have a more dynamic spreadsheet that updates in real time. ????Link to the Spreadsheets we will work with: 1️⃣Database: https://docs.google.com/spreadsheets/... 2️⃣Query + Importrange: https://docs.google.com/spreadsheets/... If you haven't watched the Importrange and Query function video lesson yet, it's important that you watch it to better understand the union of the two formulas. ????Importrange: • How to pull data from other spreadsheets ... ????Query: • How to pull data from other tabs of the pl... As usual, I will also leave the link to the two Spreadsheets we will work with in order to facilitate understanding and application of them. After accessing, don't forget to make a copy of your spreadsheet so you can edit and work on it freely. In each video lesson, I provide the documents for work. If this video lesson helped you, don't forget to subscribe to the channel, as every Monday, Wednesday and Friday there is a new video lesson to teach you how to MASTER Google Sheets. A big hug and success in Spreadsheets!!! #GoogleSheets #GoogleSheets #Query