Link two spreadsheets in Google Sheets
The supplied Source workbook tab represents the connected source spreadsheet. In B2 enter exactly ='Source workbook'!B2, then fill the formula down through B4 to keep this report linked to the source values.
Verified by JosephineAbout 60 secondsThe supplied Source workbook tab represents the connected source spreadsheet. In B2 enter exactly ='Source workbook'!B2, then fill the formula down through B4 to keep this report linked to the source values.
Step-by-step
Select the targetThe supplied Source workbook tab represents the connected source spreadsheet.
Complete the next actionIn B2 enter exactly ='Source workbook'!B2.
Apply the changefill the formula down through B4 to keep this report linked to the source values.
Shortcut or faster method
Select the target cell, type or paste the formula in the formula bar, then press Enter.
Expected result
B2:B4 contains live formulas linked to the supplied source workbook values 210, 340, and 180.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select B2 and repeat the final action. B2:B4 contains live formulas linked to the supplied source workbook values 210, 340, and 180.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Order | Linked amount |
| A-201 | |
| A-202 | |
| A-203 |
Video transcript
- Open the prepared Linked report spreadsheet.
- Select the target. The supplied Source workbook tab represents the connected source spreadsheet.
- Complete the next action. In B2 enter exactly ='Source workbook'!B2.
- Apply the change. fill the formula down through B4 to keep this report linked to the source values.
- B2:B4 contains live formulas linked to the supplied source workbook values 210, 340, and 180.