How To Automatically Copy Cells In Excel To Another Sheet

You've got information in one canvas in your spreadsheet, and want to employ it in another canvass. Y'all could copy it—only then, when you alter the information in i sheet, you'll have to change it in the other canvas, too.

In that location's a ameliorate option—link your spreadsheet cells to keep the same data in each identify. Here's how in Google Sheets (and the same fox works in Excel, Numbers, Quip, and other popular spreadsheet apps):

Link Spreadsheet Cells with !

Reference Cell in Google Sheets

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

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

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

Now, if you modify the information in the original B3 cell in the Names sail, the data volition update everywhere you've referenced that prison cell.

Need to summate values from that cell? Just type the remainder of your function as normal. If Names!B3 has the value 3 and you lot type =Names!B3*three, you'll get the outcome nine in your new jail cell every bit yous'd look.

Connect Sheets in Different Spreadsheets

Have cells in two different spreadsheets that you lot desire 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 jail cell, and copy it over to your other spreadsheet to keep things up-to-date beyond spreadsheets and accounts.

Now, with your data linked, you lot'll save time without having to re-create and paste data–and volition exist certain to always have the correct data in every canvass.

Question asked by Andrea

Get productivity tips delivered straight to your inbox

Nosotros'll email you 3 times per week—and never share your data.

Matthew Guay

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