Summary
The Importrange function that helps you to import range of cells from one spreadsheet to in another spreadsheet.
Purpose
Import data from one sheet to another sheet
Syntax
=IMPORTRANGE(“Source URL”, “Tab Name!Range”)
Arguments
Source URL: URL from where you want the data to be copied
Tab Name: Tab from the sheet where you want the data to be copied
Range: Tab range A1:I100
Example
In above image, we have explained how to import data from one to another sheet in Google Sheet. You can use like this: