Рет қаралды 7,197
The IMPORTRANGE function imports a range of cells from a specified worksheet.
This is a very useful function when, for example, you want to provide a customer or a collaborator with a document to be displayed that contains only what is necessary and that is clean of other tabs, formulas and calculations but at the same time that is automatically updated. when the source data changes.
This does not mean that with IMPORTRANGE it is not possible to perform calculations on the data, in fact it is possible to apply, for example, the Filter or Search.Vert function. However what I am sharing with you is a method, which is the actual calculations in the source sheet and only imports the desired output. This will make the formulas a lot less complex and the job a lot easier.
Let's take an example, I have a Google Sheet with these 2 tabs that contain monthly traffic reports from 2 sites. To the customer, this sheet is complex to read, he would like everything on a single sheet and with aggregated data, he would also like to be able to add notes and anything else that would annoy our work. We can create another tab for him on this document, but we risk someone accidentally compromising some data or formula or the data in the source sheets. For this reason we will be able to create for ourselves, in a new tab, the result of the sheet that the customer will view, including the data of both sites in a defined way and added together. At this point we can import this information as it is in a new document, with the IMPORTRANGE function.
The syntax involves entering as parameters the URL of the worksheet from which to import the data, which is practically the web address of the source file, from the beginning up to 'edit', semicolon, and the name of the sheet followed by the range of cells to import (the latter separated by an exclamation point).
The first time the target sheet imports data from a new source sheet, the user is prompted to authorize the operation. It is necessary to provide these permissions explicitly, ie by clicking on the target cell and on the relative "Allow access" button to link these sheets.
And here is the information structured as desired. It will be enough to share this file to the customer, who will be the one who will authenticate and who will have to open, and will be able to view the data that is always updated by being able to insert the notes he wants next to it, this file is completely for his consumption.
A note: once access is granted, any destination sheet editor can use the IMPORTRANGE function to import data from anywhere in the source worksheet. Access to use the data to be imported remains until the user who authorized it is removed from the source sheet.
I hope you enjoyed this video and that the approach shown will be helpful to you with your activities. Leave me a comment for any doubts, curiosities or suggestions on Google Sheets formulas and see you at the next video, bye :)
#GoogleSheets #IMPORTRANGE #Spreadsheets