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!
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.
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!!
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!
Thank you. Clear, step-by-step instructions, good pacing, good organization of ideas. Start from simple tasks, advance gradually, show potential surprises (for the array example).... Good job!
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
Thanks so much for this video! I’ve linked tabs before, but wasn’t sure how to link separate files! This was extremely helpful. Now I can use the formula to reference a live digital inventory for my business.
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.
@@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
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
I have a question in Please Is it possible to make the file and page names flexible inside IMPORTRANGE Function? So that if the name of the source file or work page is changed, the function will still work
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!
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.
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?
Thank you for the video ! I had first a problem with the sheet where I imported data from another sheet. It wrote me 00 : 00 : 00. I solved this by changing the type of data of the column by type "numbers".
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..
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
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
Thanks for the data. How can I generate internal links for an ebook, I need to get internal links from the Table of Contents to the specific chapter. Would you please tell me how to do that? I appreciate it.
Hello, at 10:24 I don't get this popup, for me it stays at "Loading..." and doesn't turn to "#REF!" which means I can't connect these sheets, also I'm the owner of both sheets, any idea on how to fix that?
I have a spread sheet i want to link to another tab and have the text on one tab organize itself on another tab based on text. Or a certain selection. Is that possible at all?
is there a keyboard command for the copying the cell link and pasting it to another? because i'd been dealing with thousands of rows that it's hard to pinpoint the name of the cell
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!
what the hell happens before 8:28?
@@misa80209 not a lot, but that's what i was looking for thanks Jonmitchell5326
First half: linking from tab to tab
Second half starting at 8:24: linking from file to file
hero
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.
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!!
Glad it helped!
Educational videos like these deserves more thumbs up and praise than smartphone reviews.
Thanks! Maybe I should start doing smartphone reviews in spreadsheets :)
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!
Your videos are helping me a lot. A thank you from Brazil.
The most simplest version of copying cell information. Thank you.
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.
Me too. Thx a lot for highlighting this :)
Thank you! Your explanation was clear and thorough.
Thank you. Clear, step-by-step instructions, good pacing, good organization of ideas. Start from simple tasks, advance gradually, show potential surprises (for the array example).... Good job!
I love all of your Google Sheet videos! You do such a great job! Thank you so much!
👍
I feel like such a noob for not knowing this sooner hahah. Thanks for giving me a good intro into database management inside sheets
great and deeper understanding of linking sheets
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
You're very welcome!
Bravo! Exactly what I needed with step by step instructions that are very clear!
Great to hear!
OH MY GOD FINALLY I FOUND THE FUNCTION THANK YOU SO MUCH jesus that makes my life simpler
Thanks so much for this video! I’ve linked tabs before, but wasn’t sure how to link separate files! This was extremely helpful. Now I can use the formula to reference a live digital inventory for my business.
Concise, very clear description at the right pace. Thank you.
Thank You!
Awesome, just what I was looking for to help automate my class marks in Google Classroom-created sheets!
Thank you very much!!!
love this tutorial. the best very clear and thorough explaination
Thanks so much!
Very useful. I was stuck on this issue for a while now.. Thank you
thanks for your contribution to humanity. 🙌
Super...now able to link spreadsheets....thank you
Your videos are all clear and simple. Thank you! Please keep producing more :) God bless.
Excellent, I found what I needed to learn in the first 3 minutes! Great job!
Yay!
I did it!
Thank you!
Now I can open a smaller file that doesn't take 5 minutes to load!!!! 8-D
Thank you for the clear instructions!! This was so helpful!
OMG I LOVE U, I REALLY DO. UR VIDEO JUST HELPED ME WITH A BIG WORK ISSUE. MILLON THANKS FROM CHINA！
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.
Thanks for the tip. Makes you wonder why google can't automate that feature.
I'm so glad I discovered this channel. Liked and Subscribed!
Thanks! Welcome aboard!
Really good
Great video! Clear concise and helped me find what I was looking for. Yay!
👍
This is so good, omg thank you!
very useful, I got everything I needed, Thank you
This video is so perfect. Thank you so much.
Thank you so much for this!!
Exactly what I needed. importrange function has made my task so easier. Thank you heaps!
Glad it helped!
Amazing tutorial! Thank you
Terima kasih pak, semoga berkah ilmunya
You saved my life. Thank you!!!
Excellent video, so concise with steps and made it so easy to understand,. Thank you very much.
Hushhhha finally i found this.... upto this i have done billion time copy paste.
Thank you! You're such a BIG HELP 😊
Thank you. This helped a lot!
Never have I learned this in College.
Thanks a lot, BUDDY
Glad to hear that
@@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
Awesome tutorial!
Thank you, you are great!
Thank you!
Thanks!! Great video, this trick will save me a lot of time!
Great!
This helped me so much!!!
you are the best i've ever known. Thz for sharing this.
:)
Exactly what I needed! Thank you
Very Helpful 👍
Thank you for the clear explanation. Very good video.
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
👍
Thank you , from Chile
Thank you so much for this tutorial
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
I'm learning so much. Thank you for all your help! :D
Thank you so much, I searched multiple files but all in my mother language just showed hyperlinks. ❤️
👍
Really amazing video, exactly what I was looking for!!
Excellent...i learn from your videos and extensively apply in department
Wow thank you so much! I Was able to use this method for my app I'm creating with Google Spreadsheets!
Thanks a lot for a very clear explanation. This tutorial is exactly what I need.
Great to hear!
Very helpful, thanks
This is awesome!!! Thank you so much!
I have a question in Please
Is it possible to make the file and page names flexible inside IMPORTRANGE Function?
So that if the name of the source file or work page is changed, the function will still work
You're amazing 🤩
Thank you ... great info
Thank you ... most I knew but how do I create a formula for a master/locked tab to update automatically from multiple tabs throughout the year?
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!
Thanks!! This totally worked! I thought it was impossible to import a cell value from another file.
thank you, very useful!
Thank you so much for this tutorial. It was truly helpful and very clear.
Glad it was helpful!
Hurrayyyy ....thanks a lot mate !!!
9:10 is linking other file
Google Sheets Workbook. Not a file.
thank you so much for this, Godbless!
👍
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.
super helpful!
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?
This helped thanks
Thank you for the video ! I had first a problem with the sheet where I imported data from another sheet. It wrote me 00 : 00 : 00. I solved this by changing the type of data of the column by type "numbers".
Really useful video. Thanks a lot.
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..
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
Thank you sooooo much for this!! You are awesome.
Thank you very much! It really helps! 😉
or do I create one large master tab that has all the info I'm tracking and then use other Tabs to display certain data in a different "view"? Thanks!
is the formula of importrange can still work properly if the access of the spreadsheet source is offline (limited access for particular people)?
Unlikely.
Thank you , from Thailand
thank you for your helpfull video
great effort thanks a lot
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
😍😍life changing thank you
Thanks for the data. How can I generate internal links for an ebook, I need to get internal links from the Table of Contents to the specific chapter. Would you please tell me how to do that? I appreciate it.
are the links to different sheets, dynamic , if data us updated, will it change in the link sheet?
Hello, at 10:24 I don't get this popup, for me it stays at "Loading..." and doesn't turn to "#REF!" which means I can't connect these sheets, also I'm the owner of both sheets, any idea on how to fix that?
I have a spread sheet i want to link to another tab and have the text on one tab organize itself on another tab based on text. Or a certain selection. Is that possible at all?
is there a keyboard command for the copying the cell link and pasting it to another? because i'd been dealing with thousands of rows that it's hard to pinpoint the name of the cell
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?
You're great thank you..