How to Link Data Between Sheets and Spreadsheets in Google Sheets

[@adilahmed749]

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

[@digital-lighthouse-marketing]

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

[@marcieJP2]

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

[@ElinorNichols]

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!

[@braceyerself11]

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.

[@jackson_blake]

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

[@jennxreads]

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]

You're welcome! Glad it came in useful.

[@reddoorsstudio]

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

[@yajnalgibno6536]

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

[@lauragordon8051]

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

[@Menlein1]

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]

you do know you can pause and re-wind?

[@ShushankitaVinodMishra]

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

[@Sheffcolelectric]

I’ve searched all day for this, brilliant 🙏

[@HamdanYouTuber]

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

[@TeachersTech]

You are welcome!

[@StarlahMutiny]

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

[@TeachersTech]

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

[@aayishanoorajalaludeen3435]

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

[@denatyeatsnuggets7274]

Incredibly efficient tutorial, and I learned even more than what I was searching for! Subscribed!

[@petewoodhead52]

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

[@grizzlie18]

You've got yourself a subscriber, sir!

[@TeachersTech]

Awesome, thank you!

[@Chinagoromnwabueze]

You're my best teacher

[@MompreneurLady]

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]

You are very welcome! Happy to help out.

[@pr4182]

This tutorial is amazing! What a lifesaver it is!

[@saioaicrifti7715]

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

[@Shfl99]

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

[@Brooke-hy7ey]

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

[@lelekogordianknot]

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

[@wihartotjakratan1908]

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

[@GayKidd-u4r]

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

[@brianking9093]

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

[@TeachersTech]

Glad you found it helpful!

[@BrandonGrass-cu1wm]

THANK YOU so much. This is exactly what I couldn't figure out!

[@jacksonjackson4532]

Umetisha sanaaaa Mzee Baba📙📙📙

[@salesprosteve]

This is a MASTERCLASS! Thank you so much

[@PaintAllThat]

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]

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

[@CameronVadnais-t8g]

You are a great teacher.

[@TValhendi]

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

[@TheRAjaramillo]

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

[@TeachersTech]

You're welcome!!

[@faridi-bin-Zouq]

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

[@cambriankabaroff]

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

[@LeTranNgocThaoTESOL]

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

[@ulugbekinamov3417]

Thanks for the lesson teacher l, keep up the good work

[@TeachersTech]

You’re welcome!

[@ziadbaroudi8272]

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

[@joanaleeflores7831]

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

[@JennaHogan]

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

[@dailymind]

Extremely helpful tutorial! Well explained.

[@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.

[@christinejoyceperez516]

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

[@Epiha]

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.

[@Queenlemoncake]

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.

[@professorelton197ingles4]

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

[@TeachersTech]

You’re welcome! Thanks

[@JohanaELaik]

Thank you so much Question How can we link 2 different sheets for synchronisation of modifications. For instance sheet 1 is the master. Sheet 2 only some criterias of sheet 1 selected (importrange or else) If i modify master update automatic on sheet 2 If adding information on sheet 2 how to make it synchronize with master for specific lines ?

[@diemidol1997]

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

[@TeachersTech]

You are welcome!

[@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

[@milhouse14]

This is very helpful. Many thanks. 😊

[@mariarodrigu3zapps]

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

[@mr.fixcamer]

Exactly what I was looking for ❤

[@leighsilvestri4946]

Thanks so much! Saved me so much time later on.

[@TeachersTech]

You're welcome!

[@adamgossers5392]

Perfectly explained. Thankyou.

[@CR7UX]

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

[@kristynrebeccatk1899]

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

[@duonghuyen1410]

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

[@benhewett5987]

Thanks legend. Hope you're having a great day too.

[@TeachersTech]

You too!

[@rachel9958-c9v]

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

[@dancaton]

Fantastic work - Really helped me out.

[@trafinugrohomm7055]

So good explanation! Thank you so much

[@andresjr.sumulat66]

Thank you Sir, it helps me a lot!

[@kingfelix9143]

Thank you so much. This was very helpful

[@colleenthome2145]

Thank you!! Very helpful. Is there also a way to have the formatting carry over from the original file you're linking too?

[@puszkatech]

Have you figured it out?

[@VelocityInfo]

You're the man, thank you!

[@irena4594]

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

[@cactusjoon]

thank you for this incredibly useful video tutorial!

[@wertyghjkl-fc3dx]

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

[@Victoriathewriter]

Please direct me to the library

[@catharinabhler7242]

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

[@IanMullen55]

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!

[@DejaLulu]

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

[@tayconomy]

this is so helpful omfg bless you!!!

[@rufeena]

Thanks a lot. I was looking for this

[@TioFuan]

Thank you! Super helpful...

[@luchomilan1308]

Thank you so much for the information! Really valuable!

[@pr4182]

Awesome video! You are amazing!

[@shedyt]

Thank you!!! Perfect :)

[@TeachersTech]

You're welcome!

[@allydouglas2715]

Excellent So clear

[@suryasisroychowdhury5370]

Great video sir . I was getting stuck at the last part

[@nfurtas2010]

Thank you so much for this video :)

[@ssiysoksieikdysi9929]

chuc ban luon thanh cong trong cuoc song bai huong dan tuyet voi

[@customerservices2979]

Great video, very easy to follow and understand, does this method also alow it to work backwards? e.g. if i have 2 sheets on differnt spreadsheets which are identical for data imput and once one is filled out the other is also updated both ways?

[@Matthew_Ma1201]

Excellent! Many thanks!

[@Василий-г9э5б]

my guy, thank you! only one thing - the formula needs a semicolon, not a coma between url and range

[@sumitsssaluja]

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

[@bmiller7017]

Good explanation. Do you have to have the source sheet open to have it update the total sheet? Is there a way to know when the total sheet was last updated from the source sheet?

[@mevshah8866]

Great stuff! thank you

[@ABHI_is_afk]

Excellent ❤❤❤❤

[@carissakusilek1841]

great video. thank you. is there a way to copy the formatting of the cell, not just the numbers/characters in the cell when linked from one sheet to another?

[@aolvera]

great video thank you!

[@RochelleBeggs]

Thank you for this!!! is there a way to have two way editing? so if you update in the All Schools tab it will update in the other relevant tab?

[@FreePalastine661]

Tank you very very very ....much 😊

[@jayrichey2926]

Thank you thank you thank you!

[@TeachersTech]

You are so welcome!

[@bobmason2858]

When I add a row to the spreadsheet I import data from it changes the information on my second spreadsheet. Is there a way I can have the second spreadsheet follow the original data (not the assigned cells) that I "Linked to" so I can edit the original spreadsheet?

[@balanceiseverything2565]

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

[@bendowling8357]

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?

[@kavinafis]

What if I want to dynamically add rows to a spreadsheet? In my use case I want people to fill up a google form, send that data to a spreadsheet then send it to a different spreadsheet. So each time the form is filled a new row should be added to both the spreadsheets.