Google Sheets - Linking Data Between Sheets (Workbooks, Files) & Other Worksheets (Tabs)

[@jonmitchell5326]

Anyone wanting to quickly jump to where he talks about linking two different Google Sheet files or workbooks, jump to 8m:28s in the video. Great content here!

[@misa80209]

what the hell happens before 8:28?

[@marksawesomeadventures]

What I like most about the Way you teach is while you are teaching, you always throw in some tips and tricks that would probably take YEARS to learn any other way. Thanks.

[@robertacacuci]

First half: linking from tab to tab Second half starting at 8:24: linking from file to file

[@craiggoodwin9227]

hero

[@pleenis]

After scouring the web for an answer, this was the only instruction that showed me exactly what I needed. Thank you SO much for your contribution to the Google Apps educational content. You're awesome!!

[@ExcelGoogleSheets]

Glad it helped!

[@frankyfernandes6283]

You earned new a subscriber. Thanks. Was looking for linking data from two different sheets. This was explained after 8th minute. So found the help.

[@ShebaMuturi]

Me too. Thx a lot for highlighting this :)

[@pkt4602]

Your videos are helping me a lot. A thank you from Brazil.

[@srinaansella5197]

Wow! What a simple, practical but thorough information! I used to work with Excel a lot but I'm starting to work with Google Sheets now and needed to link data. So thankful for your video; keep up the good work!

[@tronskie]

Educational videos like these deserves more thumbs up and praise than smartphone reviews.

[@ExcelGoogleSheets]

Thanks! Maybe I should start doing smartphone reviews in spreadsheets :)

[@abbybluemusic]

OH MY GOD FINALLY I FOUND THE FUNCTION THANK YOU SO MUCH jesus that makes my life simpler

[@karenoliver5494]

love this tutorial. the best very clear and thorough explaination

[@ExcelGoogleSheets]

Thanks so much!

[@salquinn2909]

ive been struggling with my spreadsheets for a few days now. thank you, you were easy to understand and easy to follow. exactly what i needed. thank you

[@ExcelGoogleSheets]

You're very welcome!

[@breannahelgerson465]

Thank you! Your explanation was clear and thorough.

[@17emsofie98]

Thank you so much, I searched multiple files but all in my mother language just showed hyperlinks. ❤️

[@ExcelGoogleSheets]

👍

[@LiquidFlower]

I feel like such a noob for not knowing this sooner hahah. Thanks for giving me a good intro into database management inside sheets

[@rockmanananan]

Thank you so much for this!!

[@douglasbuchanan8039]

Concise, very clear description at the right pace. Thank you.

[@ExcelGoogleSheets]

Thank You!

[@abubakarrk.conteh325]

great and deeper understanding of linking sheets

[@lluiszardoyaVLOGS]

This is so good, omg thank you!

[@melvinvidalrodriguezdelacr7697]

thanks for your contribution to humanity. 🙌

[@stephentierney7257]

Super...now able to link spreadsheets....thank you

[@mirnapena5316]

Bravo! Exactly what I needed with step by step instructions that are very clear!

[@ExcelGoogleSheets]

Great to hear!

[@HolisticMinistryPPBS-tx2pw]

Awesome, just what I was looking for to help automate my class marks in Google Classroom-created sheets! Thank you very much!!!

[@kylemoore8952]

I love all of your Google Sheet videos! You do such a great job! Thank you so much!

[@ExcelGoogleSheets]

👍

[@DarkMoonDroid]

Yay! I did it! Thank you! Now I can open a smaller file that doesn't take 5 minutes to load!!!! 8-D

[@kim4kids]

Thank you for the clear instructions!! This was so helpful!

[@tinikchisopanischool7622]

Very useful. I was stuck on this issue for a while now.. Thank you

[@johnnerickdavid3227]

Your videos are all clear and simple. Thank you! Please keep producing more :) God bless.

[@GuillermoRuizSuarez]

very useful, I got everything I needed, Thank you

[@raysurx2010]

Excellent, I found what I needed to learn in the first 3 minutes! Great job!

[@lutfidwir]

Terima kasih pak, semoga berkah ilmunya

[@realestateTCPro]

Excellent video, so concise with steps and made it so easy to understand,. Thank you very much.

[@priskizzle]

Great video! Clear concise and helped me find what I was looking for. Yay!

[@ExcelGoogleSheets]

👍

[@Marksmal]

Thanks!! Great video, this trick will save me a lot of time!

[@ExcelGoogleSheets]

Great!

[@n.a.792]

Amazing tutorial! Thank you

[@WhatChelseaEats]

Thank you. This helped a lot!

[@somnathkale1085]

Hushhhha finally i found this.... upto this i have done billion time copy paste.

[@pennywang778]

OMG I LOVE U, I REALLY DO. UR VIDEO JUST HELPED ME WITH A BIG WORK ISSUE. MILLON THANKS FROM CHINA！

[@kylelarimore955]

Wow thank you so much! I Was able to use this method for my app I'm creating with Google Spreadsheets!

[@mindfulorientation2838]

QUESTION: When you import the sum of range of cells (versus only the cell with total) from one workbook to another (not sheets within same wkbk) and you delete one value from the original range, do you have to adjust your formula? (As you mentioned when you link to the cell with total only).

[@ramin2881]

This is my question too, anyone can help?

[@camaronfoster3663]

This video is so perfect. Thank you so much.

[@arishadashkoff6747]

Thank you, you are great!

[@ExcelGoogleSheets]

Thank you!

[@Nevir202]

5:04 Actually, you can just put the range in curly brackets and make an array, ={B4:B8} works just fine for that. And the same works for anything within the same worksheet where you're just importing a range, rather than wanting to get the result of some calculations performed on that range.

[@Answerphone]

Thanks for the tip. Makes you wonder why google can't automate that feature.

[@Sistanatus]

You saved my life. Thank you!!!

[@siddheshtiwari1605]

Never have I learned this in College. Thanks a lot, BUDDY

[@ExcelGoogleSheets]

Glad to hear that

[@siddheshtiwari1605]

@@ExcelGoogleSheets also, I need some more help ..... I run Online Service for Stock Market and I have a lot Members in my program and they pay me on monthly basis. Each member pays me on different dates so sometimes it difficult to keep track of payments. Is there any way I can set alarms/reminder on my spreadsheets. Like I don't have set it for each and every member but it will automatically sort according to dates and then give me upcoming due or something like that

[@sergheyzaporojanu6872]

Hey! thank you so much for the deepdive about this beautiful function. I am curios if it is possible crosslink 2 files between eachother in the same table. I hope I'm not confusing you too much. Basically I have 2 tables: Questions and Answers. And I just want to connect them together. But the challenge is when the row is inserted in Questions table, I am have misaligned response rows from Question table. I'm really curious about this idea since it would allow me a data exchange without oversharing the file where the Experts are answering the questions. I really appreciate your support!

[@sksinha6364]

Very Helpful 👍

[@bellelili7808]

Thank you so much for this tutorial

[@summersalt3629]

Thanks a lot for a very clear explanation. This tutorial is exactly what I need.

[@ExcelGoogleSheets]

Great to hear!

[@maxie6990]

Exactly what I needed! Thank you

[@Callisto000]

Really amazing video, exactly what I was looking for!!

[@wanakaparagliding]

Thank you for the clear explanation. Very good video.

[@brilliantpy]

Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)

[@ExcelGoogleSheets]

👍

[@pengseya_accladp6978]

thank you for your helpfull video

[@ImaniJHicks]

This helped me so much!!!

[@mdthossain2268]

Thank you for help

[@teenagestacker6063]

This helped thanks

[@JohnNunez2905]

I'm learning so much. Thank you for all your help! :D

[@karuneshmaan]

Very helpful, thanks

[@susandaniel3996]

Thank you ... great info

[@alvarezadriannenicole4368]

thank you so much for this, Godbless!

[@ExcelGoogleSheets]

👍

[@Bethsbeautydiary]

This is awesome!!! Thank you so much!

[@paulloup5210]

Thank you , from Chile

[@prakash177]

Really useful video. Thanks a lot.

[@leeatbruhl7323]

Thanks for your helpful videos! How can I create 2 way sync between google sheets? So I can enter data into one sheet or the other and have it update (and not give an error) in the other sheet

[@RajaGiri_tvpm]

Learn Link Data Thank you 👍🙏

[@hfattahyou]

great effort thanks a lot

[@daacify]

Thank you for this. worked well if you are adding a range of cells from one file to another... (example N6:N20) but how do add specific cells from another file to another? I only want to add for example N6, N8, N20. I tried replacing colon with commas but that does not work with SUM(IMPORTRANGE command you reference.

[@sanjaybabur786]

Your channel is absolutely amazing, it has really helped me significantly. I do have one question, can we freeze data once imported via importrange function. So even if changes are made in the mother sheet, they will not reflect on the imported sheet ?

[@ReTiandAdventures]

I Hava same question 5 months after you typed here. Did you get any answers from anywhere?

[@rambojacksonjr7887]

is there any way to say link an entire sheet to a single cell on another sheet. like a link to bring up a different page or sheet?. see it all the time with coding or websites

[@hazelinechan8668]

Thank you very much! It really helps! 😉

[@Lil-ym5sn]

Thank you sir, but I have question please advise me( I need this formula implemented automatically if I add new sheet. Example if I add old people and I need to pull some cells into summary automatically when I add the old new sheet beside new sheet. Really appreciate it

[@jatindramalik3122]

Sir I watched all your videos ,please make a video (how to link 3 google sheet 1 is containing 2 drop down data .when I assign data from the drop down sheet another 2 sheet will be changed automatically.)))

[@lholhofox]

Broo I am eating your content, lol!! THANK YOU!!

[@abigailwinn3701]

THANK YOU SO MUCH!

[@iamjayangela_]

great Video thank you! Is there a way to create a button to automatically link the data to a certain section without having to type the formula out? That would be nice.

[@pichit.raetai]

Thank you , from Thailand

[@riteshsawant4708]

You're great thank you..

[@ReTiandAdventures]

Thank you

[@LauraEllen999]

Thank you sooooo much for this!! You are awesome.

[@ikarimameen]

You're amazing 🤩

[@ferdanydark]

Muchas gracias!!! me sirvió muchísimo!!!

[@dmitrygubin5187]

9:10 is linking other file

[@yomajo]

Google Sheets Workbook. Not a file.

[@dblassc]

let's say you already use the "Importrange" function in a worksheet, could you use that sheet range as a source on a Pivot table located in a different workbook?

[@mehdigolil]

super helpful!

[@mkt_2023]

Thank you for the lesson! I have a question..I create a model for documents with hundreds of cell intervals (ex.B2:B2) linked between 1 sheet (imput) and other 4 sheets (ouputs) and I want to use it all with different data. If a create a copy it will create a new link and it should be update for every cell. Is there any way to update the link on the sheets, maybe with a multiple selection? I can't find an answer but I think it should be possible! Thnks in advance..

[@anthonygikuri]

Fantastic

[@krisko963]

Hurrayyyy ....thanks a lot mate !!!

[@FAHADKHAN7]

Suppose If I want a particular Julio Castillo workbook from people workbook!! it gives all the history purchase of Julio Castillo in one place!! please help!!

[@sunthoo]

I learnt a lot from your Tutorials sir. I would like to know your name.

[@Longliveicecream]

😍😍life changing thank you

[@stacycole6664]

This was helpful I was able to follow the steps very easily. I link 2 google sheets together, but when I tried to link another sheet I got an error that said 'cannot find range or sheet for imported range'. Why would this happen and how can I fix this?

[@ExcelGoogleSheets]

Double check your tab name. Could be a space or other character causing the issue.

[@andreinamorosa]

Excellent as always. Thanks so much for your work in showing all that tutorial videos... Could you help me finding any way to automatically open and close files with scripts in Java? Do you have any tutorial for this?

[@ExcelGoogleSheets]

I'm not sure what you mean by "open and close files".

[@GurLongia]

Good

[@Fllxers]

How do you get it to also copy the formatting from the master spreadsheet to the other spreadsheet?

[@catalinboutiuc5473]

excellent

[@kimwilder5842]

I have linked one google sheet into another google workbook successfully, except, the formatting in the orignal worksheet (text strikethrough, colored cells, etc) didn't transfer. Is there a way to also get the formatting to transfer?

[@MRB_TV]

can you do a tutorial on how to link the inserted image in different worksheet? then if you change the inserted image, all the images with the same image that linked to the inserted image will also change in different worksheet at the same time.

[@medasbabu]

are the links to different sheets, dynamic , if data us updated, will it change in the link sheet?

[@diaszstudio]

Hi, Great video. Can I ask you how to display for example a date range with certain value to other sheets with date condition? for example, I have a list of date and events on other sheets, and then I want to show it on other sheets if I put certain dates it will show what event listed on other sheets. Thanks!

[@NewToneProducer]

Thank you for this video! If I want the range of the tab I'm importing to be the entire tab, what would I type for the range?

[@keleburnside9466]

When using Importrange the workbook I am importing from has colored cells, I need the colored cells to import as well. How do I do that?