How To Copy Data From One Tab To Another Automatically in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to copy data from one tab to another automatically in Google Sheets.

How To Copy Data From One Tab To Another Automatically in Google Sheets

Do you need to copy data from one tab to another in Google Sheets automatically?

If so, you can try using the QUERY function to synchronize tables in different tabs in the same Google Sheets document.

The QUERY function is a powerful function that allows you to retrieve and manipulate data from a specified range. This can be extremely helpful if you need to copy data regularly from one sheet to another, or if you want a particular table to update every time the original table is updated.

In this guide, we will explain how to use the QUERY function to copy data from one tab to another in Google Sheets.

How To Transfer Cells Automatically From One Sheet To Another in Google Sheets

Here’s how to transfer cells automatically from one sheet to another in Google Sheets.

Step 1

First, identify the cell range you want to copy.

In this example, we want to create a copy of the cell range A1:E21 in a new tab. The data should update every time changes are made to the original range.

Step 2

In the new tab, click an empty cell and input the string “=QUERY(“ to start the QUERY function.

Step 3

Next, enter the cell range you want to copy as an argument of the QUERY function.

You can quickly select the range by navigating back to the original sheet and using your cursor to select the desired range. Google Sheets will automatically add the sheet name to your new cell reference.

Step 4

Evaluate the function by pressing the Enter key.

The QUERY function should now return the data from the source range.

Do note that the QUERY function returns only data. The formulas and formatting of the source range will not be visible in the output.

Summary

This guide should be everything you need to copy data from one tab to another automatically in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.