How To Reference Another Sheet In Excel

You've got data in ane canvass in your spreadsheet, and want to use it in another sheet. You could copy it—simply then, when you change the data in one sheet, you'll accept to change it in the other sheet, also.

At that place'southward a amend option—link your spreadsheet cells to keep the same data in each identify. Hither'due south how in Google Sheets (and the same trick works in Excel, Numbers, Quip, and other popular spreadsheet apps):

Link Spreadsheet Cells with !

To reference a cell from one sheet in some other, all y'all need to know is the canvass's proper noun and the cell'southward proper noun. Link them together with an exclamation marking.

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

Or, in that location'due south an easier option. Blazon = in your prison cell, then click the other sail and select the cell you want, and press enter. That'll type the function for you.

At present, if yous alter the information in the original B3 prison cell in the Names sail, the data volition update everywhere you've referenced that cell.

Need to calculate values from that cell? Only type the rest of your function every bit normal. If Names!B3 has the value three and you lot type =Names!B3*3, you lot'll get the event 9 in your new jail 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 spotter for new or updated data in your cell, and copy it over to your other spreadsheet to proceed things up-to-date across spreadsheets and accounts.

---

At present, with your data linked, you'll salve time without having to copy and paste data–and will exist sure to always have the correct data in every sheet.

---

Question asked by Andrea

Get productivity tips delivered straight to your inbox

We'll email y'all 3 times per week—and never share your information.

Matthew Guay

Matthew Guay is an editor and writer in Bangkok. When he's not writing, he's likely reading a new book or exploring random streets in a new city. Follow Matthew at @maguay.

Source: https://zapier.com/learn/how-to/link-spreadsheet-data/

Posted by: parkreakes2000.blogspot.com

Share this post