With IMPORTRANGE Function in Google Sheets, you can connect two sheets and fetch the data from one sheet into the other.
This could be useful when you are aggregating data from multiple Google Sheets into one Google Sheets document. For example, if you have the score of students in multiple sheets, you can use the IMPORTRANGE function to connect all these and fetch the data into one sheet.
IMPORTRANGE function takes two arguments – the spreadsheet URL and the range string. The URL can easily be copied from the URL bar (or you can copy only the key as shown in the video). In case of range string, you need to specify the sheet name as well as the cell range.
If you’re using the IMPORTRANGE function for the first time in a Google Sheets document, it will give a #REF! error when you use it for the first time. You then need to hover over the cell and click on the blue “Allow Access” button to connect the two sheets.
Read More about the IMPORTRANGE Function here:
Related Video (IMPORTDATA Function):
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos –
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here:
Xem thêm Bài Viết:
- Hướng dẫn cách sửa lỗi Svchost.exe Win 7 nhanh và đơn giản nhất
- Các mẫu sản phẩm in áo sơ mi nam nữ hot nhất hiện nay
- Oracle has been renamed “Oracle America, Inc.”
- [Free Fire] Không Tay Gaming Solo Hôn Nhau Tử Chiến Với Mollu – 1 Mạng Hôn 1 Cái
- Tùy chỉnh tối ưu hệ thống windows 10 – p06 – Cách kích hoạt và vô hiệu hóa SuperFetch