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.
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!
@@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
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.
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
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?
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.
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
Very good insightful video. How do you connect to that specific cell with a keyboard shortcut? for example on excel you would press "CTRL + [" to quickly go directly onto the cell if this was an another page, how would you do this for google sheets?
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.
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.
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".
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 ?
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!!
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
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 :)
First half: linking from tab to tab
Second half starting at 8:24: linking from file to file
hero
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!
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 :)
Your videos are helping me a lot. A thank you from Brazil.
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!
OH MY GOD FINALLY I FOUND THE FUNCTION THANK YOU SO MUCH jesus that makes my life simpler
I feel like such a noob for not knowing this sooner hahah. Thanks for giving me a good intro into database management inside sheets
I love all of your Google Sheet videos! You do such a great job! Thank you so much!
👍
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!
Thank you! Your explanation was clear and thorough.
great and deeper understanding of linking sheets
Thanks!
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!!!
Bravo! Exactly what I needed with step by step instructions that are very clear!
Great to hear!
Yay!
I did it!
Thank you!
Now I can open a smaller file that doesn't take 5 minutes to load!!!! 8-D
Super...now able to link spreadsheets....thank you
Great video! Clear concise and helped me find what I was looking for. Yay!
👍
Excellent, I found what I needed to learn in the first 3 minutes! Great job!
Very useful. I was stuck on this issue for a while now.. Thank you
This is so good, omg thank you!
Your videos are all clear and simple. Thank you! Please keep producing more :) God bless.
thanks for your contribution to humanity. 🙌
love this tutorial. the best very clear and thorough explaination
Thanks so much!
OMG I LOVE U, I REALLY DO. UR VIDEO JUST HELPED ME WITH A BIG WORK ISSUE. MILLON THANKS FROM CHINA！
very useful, I got everything I needed, Thank you
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!
Terima kasih pak, semoga berkah ilmunya
Thanks!! Great video, this trick will save me a lot of time!
Great!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
👍
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
Hushhhha finally i found this.... upto this i have done billion time copy paste.
Thank you. This helped a lot!
Thank you so much for this!!
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
you are the best i've ever known. Thz for sharing this.
:)
Thank you, you are great!
Thank you!
Thank you so much, I searched multiple files but all in my mother language just showed hyperlinks. ❤️
👍
This video is so perfect. Thank you so much.
Very Helpful 👍
I'm so glad I discovered this channel. Liked and Subscribed!
Thanks! Welcome aboard!
Really good
Exactly what I needed. importrange function has made my task so easier. Thank you heaps!
Glad it helped!
Amazing tutorial! Thank you
Excellent video, so concise with steps and made it so easy to understand,. Thank you very much.
Wow thank you so much! I Was able to use this method for my app I'm creating with Google Spreadsheets!
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
Awesome tutorial!
Broo I am eating your content, lol!!
THANK YOU!!
Thank you! You're such a BIG HELP 😊
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.
Thank you for the clear instructions!! This was so helpful!
Really amazing video, exactly what I was looking for!!
Thank you so much for this tutorial
This helped me so much!!!
You saved my life. Thank you!!!
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
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?
Really useful video. Thanks a lot.
You're amazing 🤩
Very helpful, thanks
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.
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?
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..
thank you for your helpfull video
thank you, very useful!
thank you so much for this, Godbless!
👍
Thanks!! This totally worked! I thought it was impossible to import a cell value from another file.
How do you get it to also copy the formatting from the master spreadsheet to the other spreadsheet?
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 for the clear explanation. Very good video.
Very good insightful video. How do you connect to that specific cell with a keyboard shortcut? for example on excel you would press "CTRL + [" to quickly go directly onto the cell if this was an another page, how would you do this for google sheets?
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.
This helped thanks
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.
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?
are the links to different sheets, dynamic , if data us updated, will it change in the link sheet?
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 very much! It really helps! 😉
Would arrayformula work in refreshing words data filter if I add stuff on master sheet
Excellent...i learn from your videos and extensively apply in department
This is awesome!!! Thank you so much!
Thank you so much for this tutorial. It was truly helpful and very clear.
Glad it was helpful!
Is is possible to copy the entire tab with it's design? colors, font size, everything.
Thanks a lot for a very clear explanation. This tutorial is exactly what I need.
Great to hear!
Hurrayyyy ....thanks a lot mate !!!
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 ?
I Hava same question 5 months after you typed here. Did you get any answers from anywhere?
great effort thanks a lot
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!!
Learn Link Data Thank you 👍🙏
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?
super helpful!
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
so if the cells are link and you change a cell in one tab is it simultaneously changed in the linked tab?