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.
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".
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
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 ?
Many thanks for your wonderful lessons! Do I understand correctly that when IMPORTRANGE is used, links to the cells are always absolute? Can we make them relative the same way as within one spreadsheet?
Not only they are absolute, but they are also literally text references. So if you add remove columns or make any other changes to your source data you will need to manually update the range.
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.
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.)))
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?
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
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 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
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).
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
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 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..
How to make a pre formulated sheets for every day, And how to get the closing stock of day in the the opening stock of the next day. so that i just need to throw the daily closing data according to the date. Pls help me.
Sir, With due respect, I am the biggest fan of your channel of videos. such a great video. I have a problem. I have some spreadsheets so I can't protect the passed date cell automatically. I don't use data validation. because If I use data validation then spread sheet share anybody he can change. But I am an admin/ owner. I want nobody to change the date cell. how is it possible....? How to control another spreadsheet to another spreadsheet..?🙏🙏🙏 Please help me
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?
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!
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?
Thank you for your great tutorials! I Have a question. How can i use data validation making a drop down menu with data from another file ? example file 1 - To make the drop list with data from file 2 file 2 - Data In criteria on data validation window i put the formula but it does not work. Thanx in advance for your help.
Thank you for the detailed step-by-step video. Can the data range of a chart reference a tab range present in another worksheet? When I try the IMPORTRANGE function in a chart, it says "Please select a valid range". Is there another way to do this? Cheers!
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?
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!!
Thank you so much for your videos. But I have a google spreadsheet where I created a Master worksheet and several other worksheets (same date). What I want is for the data to automatically update on the other worksheets when i update the Master worksheet data. How is this possible to link? the data is so massive uggh i'm frustrated at this point, any help is greatly appreciated.
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.
Hi sir! I just want to ask how to link cell to another sheet , without changing its format (bold, font color, cell color, etc.) I've been trying it but all the formatting I did in the original sheet were not carried over to linked cell. I just used the formula guide (=Sheet1!A1) Thank you very much.
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?
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.
First half: linking from tab to tab
Second half starting at 8:24: linking from file to file
hero
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!
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!
Educational videos like these deserves more thumbs up and praise than smartphone reviews.
Thanks! Maybe I should start doing smartphone reviews in spreadsheets :)
The most simplest version of copying cell information. Thank you.
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!
Your videos are helping me a lot. A thank you from Brazil.
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!
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.
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.
I feel like such a noob for not knowing this sooner hahah. Thanks for giving me a good intro into database management inside sheets
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!!!
Thank you! Your explanation was clear and thorough.
Yay!
I did it!
Thank you!
Now I can open a smaller file that doesn't take 5 minutes to load!!!! 8-D
love this tutorial. the best very clear and thorough explaination
Thanks so much!
I love all of your Google Sheet videos! You do such a great job! Thank you so much!
👍
Your videos are all clear and simple. Thank you! Please keep producing more :) God bless.
Exactly what I needed. importrange function has made my task so easier. Thank you heaps!
Glad it helped!
Bravo! Exactly what I needed with step by step instructions that are very clear!
Great to hear!
Thank you so much, I searched multiple files but all in my mother language just showed hyperlinks. ❤️
👍
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.
Excellent video, so concise with steps and made it so easy to understand,. Thank you very much.
This is so good, omg thank you!
Very useful. I was stuck on this issue for a while now.. Thank you
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".
great and deeper understanding of linking sheets
Excellent, I found what I needed to learn in the first 3 minutes! Great job!
Super...now able to link spreadsheets....thank you
Thanks!! This totally worked! I thought it was impossible to import a cell value from another file.
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 for your contribution to humanity. 🙌
Hushhhha finally i found this.... upto this i have done billion time copy paste.
Thank you so much for this!!
Great video! Clear concise and helped me find what I was looking for. Yay!
👍
I'm so glad I discovered this channel. Liked and Subscribed!
Thanks! Welcome aboard!
Really good
Thank you for the clear instructions!! This was so helpful!
Thank you. This helped a lot!
Wow thank you so much! I Was able to use this method for my app I'm creating with Google Spreadsheets!
very useful, I got everything I needed, Thank you
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
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?
Terima kasih pak, semoga berkah ilmunya
Thanks!! Great video, this trick will save me a lot of time!
Great!
Excellent...i learn from your videos and extensively apply in department
Thanks a lot for a very clear explanation. This tutorial is exactly what I need.
Great to hear!
This video is so perfect. Thank you so much.
Many thanks for your wonderful lessons! Do I understand correctly that when IMPORTRANGE is used, links to the cells are always absolute? Can we make them relative the same way as within one spreadsheet?
Not only they are absolute, but they are also literally text references. So if you add remove columns or make any other changes to your source data you will need to manually update the range.
Amazing tutorial! Thank you
Really amazing video, exactly what I was looking for!!
Thank you so much for this tutorial. It was truly helpful and very clear.
Glad it was helpful!
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.
You saved my life. Thank you!!!
Thank you! You're such a BIG HELP 😊
Thank you for the clear explanation. Very good video.
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.)))
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
👍
you are the best i've ever known. Thz for sharing this.
:)
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?
I'm not sure what you mean by "open and close files".
Good
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
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.
9:10 is linking other file
Google Sheets Workbook. Not a file.
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?
Exactly what I needed! 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
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).
This is my question too, anyone can help?
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
I learnt a lot from your Tutorials sir. I would like to know your name.
Thank you, you are great!
Thank you!
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
I'm learning so much. Thank you for all your help! :D
Thank you so much for this tutorial
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..
This helped me so much!!!
How to make a pre formulated sheets for every day, And how to get the closing stock of day in the the opening stock of the next day. so that i just need to throw the daily closing data according to the date. Pls help me.
Sir,
With due respect, I am the biggest fan of your channel of videos. such a great video. I have a problem. I have some spreadsheets so I can't protect the passed date cell automatically. I don't use data validation. because If I use data validation then spread sheet share anybody he can change. But I am an admin/ owner. I want nobody to change the date cell. how is it possible....? How to control another spreadsheet to another spreadsheet..?🙏🙏🙏 Please help me
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?
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!
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?
Double check your tab name. Could be a space or other character causing the issue.
Thank you , from Chile
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?
This is awesome!!! Thank you so much!
Thank you for your great tutorials!
I Have a question. How can i use data validation making a drop down menu with data from another file ?
example
file 1 - To make the drop list with data from file 2
file 2 - Data
In criteria on data validation window i put the formula but it does not work.
Thanx in advance for your help.
Awesome tutorial!
Thank you for the detailed step-by-step video.
Can the data range of a chart reference a tab range present in another worksheet? When I try the IMPORTRANGE function in a chart, it says "Please select a valid range". Is there another way to do this? Cheers!
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?
Broo I am eating your content, lol!!
THANK YOU!!
Very Helpful 👍
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!!
Thank you so much for your videos. But I have a google spreadsheet where I created a Master worksheet and several other worksheets (same date). What I want is for the data to automatically update on the other worksheets when i update the Master worksheet data. How is this possible to link? the data is so massive uggh i'm frustrated at this point, any help is greatly appreciated.
Try using QUERY function on your other worksheets using master as source.
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.
Hi sir! I just want to ask how to link cell to another sheet , without changing its format (bold, font color, cell color, etc.)
I've been trying it but all the formatting I did in the original sheet were not carried over to linked cell. I just used the formula guide (=Sheet1!A1)
Thank you very much.
Thank you , from Thailand
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!
8:25 linking to a different googlesheet
thank you so much for this, Godbless!
👍