The following step-by-step example shows how to autofill values from another sheet in Google Sheets.

First, let’s enter the following data into Sheet1 in Google Sheets:

Now suppose we have another sheet titled Sheet2 that contains the following data:

Suppose we would like to autofill the values from the Points column in Sheet1 into a Points column in Sheet2.

To do so, we can type the following formula in cell C2 of Sheet2:

=Sheet1!B2

This will automatically populate cell C2 in Sheet2 with the value from cell B2 in Sheet1:

To autofill the rest of the values in column C, we can hover over the bottom right-hand corner of cell C2 until a tiny “+” appears.

Then click and drag down to all of the remaining cells in column C:

Notice that all of the values from the Points column in Sheet1 have been autofilled into Sheet2.

The following tutorials explain how to perform other common tasks in Google Sheets: