SummaryThe Importrange function that helps you to import range of cells from one spreadsheet to in another spreadsheet.
PurposeImport data from one sheet to another sheet
Syntax=IMPORTRANGE(“Source URL”, “Tab Name!Range”)
ArgumentsSource 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
ExampleIn above image, we have explained how to import data from one to another sheet in Google Sheet. You can use like this: