How do You Link Data on One Spreadsheet Page to Another Sheet?

By Matthew Guay - Published June 2, 2017 -

You are reading: Chapter 8 of 2

You've got data in one sheet in your spreadsheet, and want to use it in another sheet. You could copy it—but then, when you change the data in one sheet, you'll have to change it in the other sheet, too.

There's a better option—link your spreadsheet cells to keep the same data in each place. Here's how in Google Sheets (and the same trick works in Excel, Numbers, Quip, and other popular spreadsheet apps):

Link Spreadsheet Cells with !

Reference Cell in Google Sheets

To reference a cell from one sheet in another, all you need to know is the sheet's name and the cell's name. Link them together with an exclamation mark.

Say your sheet's name is "Names", and you need the data from cell B3. Just enter =Names!B3 in any cell, and you'll get the data from that cell in your new sheet.

Or, there's an easier option. Type = in your cell, then click the other sheet and select the cell you want, and press enter. That'll type the function for you.

Now, if you change the data in the original B3 cell in the Names sheet, the data will update everywhere you've referenced that cell.

Need to calculate values from that cell? Just type the rest of your function as normal. If Names!B3 has the value 3 and you type =Names!B3*3, you'll get the result 9 in your new cell as you'd expect.

Connect Sheets in Different Spreadsheets

Have cells in two different spreadsheets that you want to link? The best option there is to use Zapier's Google Sheets workflows to link your sheets. Zapier can watch for new or updated data in your cell, and copy it over to your other spreadsheet to keep things up-to-date across spreadsheets and accounts.


Now, with your data linked, you'll save time without having to copy and paste data–and will be sure to always have the correct data in every sheet.


Have another question about Google Sheets or other apps? Ask the Zapier team

Published June 2, 2017

Question asked by Andrea

Answer written by Zapier writer Matthew Guay

Workflow

Take the Work out of Workflow

Zapier is the easiest way to automate powerful workflows with more than 1,500 apps.