Within a single spreadsheet, you can replicate data and copy it from one sheet to another.
Get data from other sheets in your spreadsheet
- On your iPhone or iPad, open the Google Sheets app
.
- Open or create a sheet.
- Select a cell.
- Type = followed by the sheet name, an exclamation point, and the cell being copied. For example,
=Sheet1!A1 or ='Sheet number two'!B4.
Note: If a sheet name contains spaces or other non-alphanumeric symbols, include single quotes around it (as in the second example).
Get data from other worksheets
Important: To reference a cell or range of cells in another spreadsheet, you must use the IMPORTRANGE function.
To pull data from other spreadsheets, open https://docs.google.com/spreadsheets/ on your computer and use the IMPORTRANGE function.