How to Link Data Between Sheets and Spreadsheets in Google Sheets

Рет қаралды 323,727

Күн бұрын

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
Here’s the link with all of the Google Spreadsheets after you open them make a copy of them under file: drive.google.com/drive/folder...

Пікірлер: 219

@JaniceRaspen 4 күн бұрын

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!

@marcieJP2 Жыл бұрын

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

@adilahmed749 Жыл бұрын

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

@user-fn5ej5ng5b Жыл бұрын

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

@Shfl99 2 жыл бұрын

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!!

@Menlein1 2 жыл бұрын

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.

@historic-newspapers 8 ай бұрын

you do know you can pause and re-wind?

@braceyerself11 2 ай бұрын

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.

@irena4594 Жыл бұрын

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

@reddoorsstudio 11 ай бұрын

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

@lelekogordianknot Жыл бұрын

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

@wertyghjkl-fc3dx 4 күн бұрын

This is so much easier to learn compared to going to the library...becoming frustrated. This is by far way less frustrating.

@digital-lighthouse-marketing 4 ай бұрын

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

@balanceiseverything2565 2 жыл бұрын

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

@Sheffcolelectric Жыл бұрын

I’ve searched all day for this, brilliant 🙏

@jennifersmith6912 2 жыл бұрын

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!

@TeachersTech 2 жыл бұрын

You're welcome! Glad it came in useful.

@pr4182 10 ай бұрын

This tutorial is amazing! What a lifesaver it is!

@jackson_blake Жыл бұрын

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

@lauragordon8051 3 ай бұрын

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

@joanaleeflores7831 6 ай бұрын

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

@user-oi8ce3oz3i 5 ай бұрын

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

@luchomilan1308 2 жыл бұрын

Thank you so much for the information! Really valuable!

@JennaHogan 9 ай бұрын

THANK YOU this was really good to follow and exactly what I was looking for!

@salesprosteve 9 ай бұрын

This is a MASTERCLASS! Thank you so much

@petewoodhead52 2 ай бұрын

Man! That was thorough! Super helpful, I learned a lot. Thank you.

@saioaicrifti7715 Жыл бұрын

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

@brianking9093 2 жыл бұрын

Excellent video Jamie. Well presented, easy to follow and very useful.👏

@TeachersTech 2 жыл бұрын

Glad you found it helpful!

@TValhendi 2 ай бұрын

Thank you very much. You helped me a lot with a clear demonstration. Appreciate

@DejaLulu 10 ай бұрын

Really useful, easy-to-follow tutorial! Cheers!

@MompreneurLady 2 жыл бұрын

Hi Jamie.... You've been a huge blessing to me and soooooo admire your CONSISTENCY!!! You helped me learn how to Edit Videos using Shot Cut!!! THANK YOU! I just learned how to add B-Rolls on my Videos. 🙏🙏🙏

@TeachersTech 2 жыл бұрын

You are very welcome! Happy to help out.

@adamgossers5392 2 жыл бұрын

Perfectly explained. Thankyou.

@Queenlemoncake 2 жыл бұрын

Thank You so much. Your directions were clear and consise. I've been wanting to link data from one spreadsheet sheet to another sheet but I could never quite figure it out.

@rachelholt9958 Жыл бұрын

Excellent video!! Thank you, thank you, thank you!

@Epiha 6 ай бұрын

Awesome! I could never get the bugger to work. Thank you! On edit, I just needed a single value and used L3:L3 and it worked.

@PaintAllThat 2 жыл бұрын

I think that this is the best video I have ever watched on any topic. Clear, concise, simple explanations, good pacing, and understandable voiceover. I have subscribed and will watch your other videos. I am interested in using macros and formulas to help automate scheduling using Google Sheets and Calendar.

@TeachersTech 2 жыл бұрын

Glad it was helpful! Thank you for the video topic suggestions.

@Brooke-hy7ey 4 ай бұрын

This answered my question in 5 seconds thank you so much!

@cactusjoon Жыл бұрын

thank you for this incredibly useful video tutorial!

@ShushankitaVinodMishra 3 ай бұрын

Thank you sooo much you saved my job. It was the most helpful video in my life.

@StarlahMutiny 2 жыл бұрын

This is literally the most perfect video to have been suggested to me at the most absolutely perfect time🙌 thank you for this!!!

@TeachersTech 2 жыл бұрын

I'm glad it came in timely for you. Have a great day!

@aayishanoorajalaludeen3435 6 ай бұрын

@@TeachersTech Hello, there. I am unable to link between sheets using the given formula ?

@christinejoyceperez516 Жыл бұрын

Thank you! this helps a lot! God bless you!

@LeTranNgocThaoTESOL 6 ай бұрын

Super easy to understand thank you so much!!!!

@CR7UX Жыл бұрын

Very great job, thank you so much for the video. You saved me so much time.

@trafinugrohomm7055 Жыл бұрын

So good explanation! Thank you so much

@mariarodrigu3zapps 11 ай бұрын

Thank you so much!!! This resolved my problem!

@ziadbaroudi8272 6 ай бұрын

Very helpful video! Thanks a lot, Teacher's Tech.

@wihartotjakratan1908 8 ай бұрын

Wow , thank you very much , you are such a great teacher.

@milhouse14 Ай бұрын

This is very helpful. Many thanks. 😊

@TioFuan 10 ай бұрын

Thank you! Super helpful...

@catharinabhler7242 11 ай бұрын

Good stuff. Thank you :) You're good at explaining.

@kristynrebeccatk1899 Жыл бұрын

cam on ban vi da chia se nhung kien thuc rat co gia tri a

@mevshah8866 7 ай бұрын

Great stuff! thank you

@kingfelix9143 5 ай бұрын

Thank you so much. This was very helpful

@duonghuyen1410 3 ай бұрын

thank you for the video, it helped me a lot today. so much appreciation!

@Matthew_Ma1201 Жыл бұрын

Excellent! Many thanks!

@dailymind Ай бұрын

Extremely helpful tutorial! Well explained.

@tayconomy 8 ай бұрын

this is so helpful omfg bless you!!!

@mr.fixcamer 10 ай бұрын

Exactly what I was looking for ❤

@cambriankabaroff 9 ай бұрын

thank you for saving me some time and energy!!!

@TheRAjaramillo 6 ай бұрын

THANK YOU! This was what i've been looking for so long...THANK YOU!!!

@TeachersTech 6 ай бұрын

You're welcome!!

@rufeena 7 ай бұрын

Thanks a lot. I was looking for this

@dancaton 5 ай бұрын

Fantastic work - Really helped me out.

@user-xt8ck3ry3i 11 ай бұрын

You're the man, thank you!

@user-dp2hc8fg8s 11 ай бұрын

You are a great teacher.

@nfurtas2010 Жыл бұрын

Thank you so much for this video :)

@katiemguinness1994 15 күн бұрын

you are awesome! what an amazing video!

@andresjr.sumulat66 Жыл бұрын

Thank you Sir, it helps me a lot!

@professorelton197ingles4 2 жыл бұрын

Amazing class, I always watch your videos when I can, thanks man

@TeachersTech 2 жыл бұрын

You’re welcome! Thanks

@ianahicl5234 Жыл бұрын

Great help. Thank

@aolvera 11 ай бұрын

great video thank you!

@aimeeernest3038 Ай бұрын

This would be a great one to add to your "Google Sheets Lessons" playlist. I am trying to learn more before a new school year and noticed it's not in that one.

@bendowling8357 2 жыл бұрын

This is really helpful, like all your videos. I use Conditional Formatting and Data Validation in the original gradebook spreadsheet that I am linking from. Do you know if it is possible for those colors and cell dropdown menus to be automatically copy over or it is case of just ensuring those conditions are set in the new spreadsheet?

@yajnalgibno6536 5 ай бұрын

The explanations are crystal clear, even though English is not my native language.

@stevengarcia4217 2 жыл бұрын

THANK YOU SOOO MUCH!!

@Chris-ed8vh 11 ай бұрын

This is great!!

@HamdanYouTuber 2 жыл бұрын

Hi, I'm from Indonesia. Thanks for the video because well presented, easy to follow and very useful.

@TeachersTech 2 жыл бұрын

You are welcome!

@justineleeper4907 6 ай бұрын

Thank you so much!

@pr4182 Жыл бұрын

Awesome video! You are amazing!

@ashokkhegde Жыл бұрын

Great. Thanks a lot.

@faridi-bin-Zouq Жыл бұрын

I love you man, you are only you are... thanks a lot from Pakistan

@diemidol1997 Жыл бұрын

Thank you so much sir! This video helps me a bunch!

@TeachersTech Жыл бұрын

You are welcome!

@allydouglas2715 Жыл бұрын

Excellent So clear

@alistine Жыл бұрын

THANK YOU!

@charliee5970 2 ай бұрын

Thank you sir!

@ummethtsright Жыл бұрын

Thank you!

@fafo2710 Жыл бұрын

thx u! so much!!! :D

@shedyt 11 ай бұрын

Thank you!!! Perfect :)

@TeachersTech 11 ай бұрын

You're welcome!

@sumitsssaluja 3 ай бұрын

Thanks a lot, sir. I have learned something new and good today:-)

@MykelMiller-zj7qk Жыл бұрын

This is super helpful. Do you know if it is possible to have bidirectional editing between two linked cells in different sheets within the same spreadsheet? ie linking b5 in All schools to c6 in Copperfield but being able to edit either and getting both to change

@IanMullen55 4 ай бұрын

What a pleasure to Learn from you Jamie, Thank you. Might you have a video that might show me how (having used importrange successfully for some 200 rows) the source sheet had come additional formatting too which would be super to reflect in my new LINKED document. A1:W200 - Plus if I wished to make the NEW linked rage READ ONLY - so as to force users to only do updates in the source document - that would be magic!