How to Autofill Values from Another Sheet in Google Sheets

To autofill values from another sheet in Google Sheets, you can use the IMPORTRANGE function. This function allows you to import data from one sheet to another within the same Google Sheets document or between different documents.

Here's how to do it:

1. Open the Google Sheets document you want to import data into.
2. In the cell where you want to start importing data, type the following formula:

=IMPORTRANGE("spreadsheet_url", "sheet_name!range")

Replace spreadsheet_url with the URL of the Google Sheets document you want to import data from. Replace sheet_name with the name of the sheet in that document where the data is located, and replace range with the range of cells you want to import.

For example, if you want to import data from cells A1 to B10 from Sheet1 in a Google Sheets document with the URL https://docs.google.com/spreadsheets/d/1AbCdEfGHiJkLmN0PqRstUvWxZy1/edit, you would use the following formula:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AbCdEfGHiJkLmN0PqRstUvWxZy1/edit", "Sheet1!A1:B10")

3. Press Enter to complete the formula. You might see a #REF! error initially.
4. Click on the cell with the #REF! error, and you'll see a small pop-up message asking for permission to access the data from the other sheet. Click "Allow access" to grant permission.
5. The data from the specified range in the other sheet should now appear in your current sheet.

Example

1. Open the Google Sheets document you want to import data into.
2. In cell A1, type the following formula:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AbCdEfGHiJkLmN0PqRstUvWxZy1/edit", "Sheet1!A1:B10")

Replace the example URL with the URL of the Google Sheets document you want to import data from.

3. Press Enter to complete the formula. You might see a #REF! error initially.
4. Click on cell A1 with the #REF! error, and you'll see a small pop-up message asking for permission to access the data from the other sheet. Click "Allow access" to grant permission.
5. The data from cells A1 to B10 in Sheet1 of the other document should now appear in your current sheet, starting from cell A1.