How to Link Data Between Sheets and Spreadsheets in Google Sheets

In this video tutorial, I will show you how to link data in Google Sheets. I will go over linking cells and ranges on the same sheet in Google Sheets. Also, I will show you how to link sheets or tabs within a spreadsheet and how you can link spreadsheets to each other using Google Sheets. The two functions that will get used in this video are ARRAYFORMULA and IMPORTRANGE.

0:00 Introduction
1:25 Linking Cells in Google Sheets
3:49 Linking Ranges in Google Sheets
6:33 Linking separate spreadsheets in Google Sheets

[adilahmed]

Brilliant tutorial. Clear, concise, and simple to follow. Thank you.

[marcieJP]

This is one of the most useful videos I've ever watched! THANK YOU for making the instructions clear and simple!!

[braceyerself]

Thank you! You do a great job of articulating things clearly, showing what you are doing, and simplifying things. Nicely done. I really appreciate it.

[fnejngb]

God bless friendly helpful teachers like this for explaining things so clearly in such a calm step-by-step manner

[JaniceRaspen]

I have to do the last part of your video once a year and of course I can never remember how to do it, so I come back to your video time after time! Thank you!

[reddoorsstudio]

thank you.I appreciate your slow clear and concise delivery. Solved my problem

[Shfl]

I was looking for something similar as group sheets in Excel for google sheets and you saved my life!!! This is amazingly helpful!!! Thank you so much!!

[digital-lighthouse-marketing]

You saved the day and saved hours of work for me. You are a wonderful instructor, thank you.

[irena]

Thank you for the video! Very simple and clear explanation at a great pace! Appreciate it!

[Menlein]

Excellent! I learned a lot in a short period. Great organization, great delivery, consistent, (maybe a bit slower for those of us taking notes) I look fwd to watching others you have done.

[lelekogordianknot]

Thank you so much ! Easy to understand, short and to the point :)

[Sheffcolelectric]

I’ve searched all day for this, brilliant 🙏

[balanceiseverything]

Great tutorial, very clear and easy to understand. Thank you :)

[joanaleeflores]

..so precise and easy to understand and follow ❤ thank you so much for this.. a big help for someone who's working on Accounting

[saioaicrifti]

xin gui loi cam on den nguoi lam clip nay, chi tiet va de hieu hon ca mong doi

[pr]

This tutorial is amazing! What a lifesaver it is!

[jackson_blake]

Amazing video. I’ve now leveled up. This video has changed my life!

[oiceozi]

Thank you so much. This has been so helpful for me assessment data collection. Very clear and not too quick too loose us.

[jennifersmith]

You read my mind! I have been trying to figure out how to do a reading spreadsheet to keep track of my personal reading information. Thank you!

[lauragordon]

Thanks so much! I was off by 3 characters and you got me on track. Appreciate you!