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!
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. 🙏🙏🙏
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.
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 ?
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!!
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.
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?
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.
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
Learning how to link separate spreadsheets is amazing! Question: What if the spreadsheet we are linking to is constantly changing? So it isn't a range? (i.e. - Everytime I add a new amount, which is also a new line, my I42 changes to I43 and so on...)
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.
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.
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?
Thank you. This is great. I do have a question. Is there a way to display the highest value in one row on one spreadsheet into another spreadsheet? Example, I am adding daily values on one spreadsheet. The second spreadsheet is a summary which shows the latest value which is usually the highest value. I only want one value to be displayed and not a sum of the entire row.
Great video thank you. I do have a question if I wanted to keep the cell formatting (Cell color, font color) format between two sheets what function do I use. Meaning if i'm referencing one cell from Sheet 1 A2 to Sheet 2 A5. If i make a change to Sheet 1 A2 and change the color i want that to reflect on Sheet 2 A5. I'm able to use ='Sheet 1' !A2. That keeps the data but doesn't match the format. Thank you
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?
I have two sheets(of the same spreadsheet) in my Google Sheets document : one named ‘daily task’ and another named ‘weekly task’. I want to automatically transfer data from the ‘daily task’ sheet to the ‘weekly task’ sheet, which is organized by day. Currently, I have to manually clear the ‘daily task’ sheet and link the data to the next day in the ‘weekly task’ sheet. Is there a way to automate this process?
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!
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?
Good day sir. I am trying to link some sheets and I was able to get one done but when I went to try to do the next one, but I keep getting an error message saying "Array result was not expanded because it would overwrite data in C11." Can you please help me with this error. I have a bunch of sheets that I want to link to another one and not sure what is going on. I'm not on Facebook, Twitter or Instagram so I can't contact you that way. If there is a way I can get in touch with you, please let me know. I would like to get these sheets linked as soon as I can. Thanks.
Hi! How about if what I want to do is: If I click Cell A2 in the School Sales sheet, it will direct me/open the sheet "Copperfield". If I click Cell A3 in the School Sales sheet, it will direct me/open the sheet Fish Creek. If I click Cell A4 in the School Sales sheet, it will direct me/open the sheet - Hawkwood. (Let's say the sheets Copperfield, Fish Creek and Hawkwood are all on the same spreadsheet: Linking Spreadsheets)
The importrange works as explained. When I have new info and have to insert a line above it, it will not follow along. Example B2:G2 when insert a row it is now B3:G3, but it has the info from the new inserted B2:G2. IS there a way to get that to follow when inserting new rows? Sometimes I will have 8 new additional lines to insert. Please let me know if there is anything, thanks
Thank you for this! How do you link cells to categories in a dropdown menu? For example I have a bookkeeping sheet that I select a category for each purchase on one page and then on the next sheet it reflects that total change for that category. Example: I write in the date, the amount, the description, and then select the category that fits that purchase. On the next sheet in the document it reflects the expenses total in that category. I know this is very long but I would really appreciate help!
the tutorial is perfectly understood. but im having problems on sorting. If i sort the main sheet that the sheet#2 is linked with, it messes up. it only sorts the cell, not the value in the cell. what shuold I do?
I created a google synch with another spreadsheet using "importrange" however if I type in the created spreadsheet the information deletes the spreadsheet .. I can type in the original google doc and the infor shows up immediately. But it will not work the other way. Bascially I would like both spreadsheets to talk to eahc other any suggestions thanks
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 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?
Hello, I have a question, so I did completely understand and using the IMPORTRANGE function but, as soon as I import my data from the excel to google sheet(not only changing the values in spreadsheet, update completely new file from the excel), url link has been changed and data couldn't update(because it goes through by url link). Is there any solution?
can we link the cell from sheet into a slides? Pulling data from certain sheet cell and have it link to slides., so when sheet are updated, so does the slide?
Greetings! Thank you for your video! Would you be so kind to tell me whether it is possible to create a link that updates automatically? I need to create a table of content for a page in a sheet that has 200+ rows. The table itself will be edited by different people and some chapters might be expanded by adding new rows. In that case, if I create a link to a cell (f.e. B76 with the words “Chapter 3”) and then add new rows before the 76th row - the link will still direct me to B76, while the cell with words “Chapter 3” is in 89th row (B89). Is it any way to solve this issue?
Hi I'm trying to do it with a =sumproduct of two columns for inventory one being price and one being quantity I'm not sure if it's possible but it doesn't seem to be working.
You saved the day and saved hours of work for me. You are a wonderful instructor, thank you.
Brilliant tutorial. Clear, concise, and simple to follow. Thank you.
This is one of the most useful videos I've ever watched! THANK YOU for making the instructions clear and simple!!
God bless friendly helpful teachers like this for explaining things so clearly in such a calm step-by-step manner
Amazing video. I’ve now leveled up. This video has changed my life!
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.
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!
You're welcome! Glad it came in useful.
The explanations are crystal clear, even though English is not my native language.
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!
thank you.I appreciate your slow clear and concise delivery. Solved my problem
Incredibly efficient tutorial, and I learned even more than what I was searching for! Subscribed!
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. 🙏🙏🙏
You are very welcome! Happy to help out.
Thanks so much! I was off by 3 characters and you got me on track. Appreciate you!
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.
you do know you can pause and re-wind?
This is literally the most perfect video to have been suggested to me at the most absolutely perfect time🙌 thank you for this!!!
I'm glad it came in timely for you. Have a great day!
@@TeachersTech Hello, there. I am unable to link between sheets using the given formula ?
I’ve searched all day for this, brilliant 🙏
Hi, I'm from Indonesia.
Thanks for the video because well presented, easy to follow and very useful.
You are welcome!
Thank you sooo much you saved my job. It was the most helpful video in my life.
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 ?
You've got yourself a subscriber, sir!
Awesome, thank you!
This tutorial is amazing! What a lifesaver it is!
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!!
Man! That was thorough! Super helpful, I learned a lot. Thank you.
You're my best teacher
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.
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?
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.
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
Excellent video Jamie. Well presented, easy to follow and very useful.👏
Glad you found it helpful!
..so precise and easy to understand and follow ❤ thank you so much for this.. a big help for someone who's working on Accounting
xin gui loi cam on den nguoi lam clip nay, chi tiet va de hieu hon ca mong doi
Learning how to link separate spreadsheets is amazing! Question: What if the spreadsheet we are linking to is constantly changing? So it isn't a range? (i.e. - Everytime I add a new amount, which is also a new line, my I42 changes to I43 and so on...)
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.
Thank you so much ! Easy to understand, short and to the point :)
THANK YOU so much. This is exactly what I couldn't figure out!
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.
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.
Glad it was helpful! Thank you for the video topic suggestions.
THANK YOU! This was what i've been looking for so long...THANK YOU!!!
You're welcome!!
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?
I love you man, you are only you are... thanks a lot from Pakistan
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?
Thank you so much. This has been so helpful for me assessment data collection. Very clear and not too quick too loose us.
This answered my question in 5 seconds thank you so much!
Thanks so much! Saved me so much time later on.
You're welcome!
Thank you. This is great. I do have a question. Is there a way to display the highest value in one row on one spreadsheet into another spreadsheet? Example, I am adding daily values on one spreadsheet. The second spreadsheet is a summary which shows the latest value which is usually the highest value. I only want one value to be displayed and not a sum of the entire row.
Wow , thank you very much , you are such a great teacher.
Great video thank you. I do have a question if I wanted to keep the cell formatting (Cell color, font color) format between two sheets what function do I use. Meaning if i'm referencing one cell from Sheet 1 A2 to Sheet 2 A5. If i make a change to Sheet 1 A2 and change the color i want that to reflect on Sheet 2 A5. I'm able to use ='Sheet 1' !A2. That keeps the data but doesn't match the format. Thank you
This is a MASTERCLASS! Thank you so much
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?
Super easy to understand thank you so much!!!!
You are a great teacher.
Amazing class, I always watch your videos when I can, thanks man
You’re welcome! Thanks
This is so much easier to learn compared to going to the library...becoming frustrated. This is by far way less frustrating.
Please direct me to the library
I have two sheets(of the same spreadsheet) in my Google Sheets document : one named ‘daily task’ and another named ‘weekly task’. I want to automatically transfer data from the ‘daily task’ sheet to the ‘weekly task’ sheet, which is organized by day. Currently, I have to manually clear the ‘daily task’ sheet and link the data to the next day in the ‘weekly task’ sheet. Is there a way to automate this process?
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!
Extremely helpful tutorial! Well explained.
thank you for saving me some time and energy!!!
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?
Good day sir. I am trying to link some sheets and I was able to get one done but when I went to try to do the next one, but I keep getting an error message saying "Array result was not expanded because it would overwrite data in C11." Can you please help me with this error. I have a bunch of sheets that I want to link to another one and not sure what is going on. I'm not on Facebook, Twitter or Instagram so I can't contact you that way. If there is a way I can get in touch with you, please let me know. I would like to get these sheets linked as soon as I can. Thanks.
Thank you very much. You helped me a lot with a clear demonstration.
Appreciate
my guy, thank you! only one thing - the formula needs a semicolon, not a coma between url and range
Hi! How about if what I want to do is:
If I click Cell A2 in the School Sales sheet, it will direct me/open the sheet "Copperfield".
If I click Cell A3 in the School Sales sheet, it will direct me/open the sheet Fish Creek.
If I click Cell A4 in the School Sales sheet, it will direct me/open the sheet - Hawkwood.
(Let's say the sheets Copperfield, Fish Creek and Hawkwood are all on the same spreadsheet: Linking Spreadsheets)
Thanks legend. Hope you're having a great day too.
You too!
THANK YOU this was really good to follow and exactly what I was looking for!
Thank you!! Very helpful. Is there also a way to have the formatting carry over from the original file you're linking too?
Have you figured it out?
Umetisha sanaaaa Mzee Baba📙📙📙
The importrange works as explained. When I have new info and have to insert a line above it, it will not follow along. Example B2:G2 when insert a row it is now B3:G3, but it has the info from the new inserted B2:G2. IS there a way to get that to follow when inserting new rows? Sometimes I will have 8 new additional lines to insert. Please let me know if there is anything, thanks
Can you also carry format? For exemple, I have A1 and B1 merged together font size 16 in bold.
Thank you for this! How do you link cells to categories in a dropdown menu? For example I have a bookkeeping sheet that I select a category for each purchase on one page and then on the next sheet it reflects that total change for that category. Example: I write in the date, the amount, the description, and then select the category that fits that purchase. On the next sheet in the document it reflects the expenses total in that category. I know this is very long but I would really appreciate help!
Thank you! this helps a lot! God bless you!
Very helpful video! Thanks a lot, Teacher's Tech.
Perfectly explained. Thankyou.
Thanks for the lesson teacher l, keep up the good work
You’re welcome!
the tutorial is perfectly understood. but im having problems on sorting. If i sort the main sheet that the sheet#2 is linked with, it messes up. it only sorts the cell, not the value in the cell. what shuold I do?
Exactly what I was looking for ❤
Really useful, easy-to-follow tutorial! Cheers!
Thank you so much sir! This video helps me a bunch!
You are welcome!
Thank you Sir, it helps me a lot!
Excellent video!! Thank you, thank you, thank you!
I created a google synch with another spreadsheet using "importrange" however if I type in the created spreadsheet the information deletes the spreadsheet .. I can type in the original google doc and the infor shows up immediately. But it will not work the other way. Bascially I would like both spreadsheets to talk to eahc other any suggestions thanks
Thank you so much!!! This resolved my problem!
This is very helpful. Many thanks. 😊
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..
Very great job, thank you so much for the video. You saved me so much time.
thank you for the video, it helped me a lot today. so much appreciation!
Thank you for the video! Very simple and clear explanation at a great pace! Appreciate it!
thank you for this incredibly useful video tutorial!
So good explanation! Thank you so much
Fantastic work - Really helped me out.
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?
Hello, I have a question, so I did completely understand and using the IMPORTRANGE function but, as soon as I import my data from the excel to google sheet(not only changing the values in spreadsheet, update completely new file from the excel), url link has been changed and data couldn't update(because it goes through by url link). Is there any solution?
Great video sir . I was getting stuck at the last part
can we link the cell from sheet into a slides? Pulling data from certain sheet cell and have it link to slides., so when sheet are updated, so does the slide?
Greetings! Thank you for your video! Would you be so kind to tell me whether it is possible to create a link that updates automatically? I need to create a table of content for a page in a sheet that has 200+ rows. The table itself will be edited by different people and some chapters might be expanded by adding new rows. In that case, if I create a link to a cell (f.e. B76 with the words “Chapter 3”) and then add new rows before the 76th row - the link will still direct me to B76, while the cell with words “Chapter 3” is in 89th row (B89). Is it any way to solve this issue?
Hi I'm trying to do it with a =sumproduct of two columns for inventory one being price and one being quantity I'm not sure if it's possible but it doesn't seem to be working.
cam on ban vi da chia se nhung kien thuc rat co gia tri a
I need help bringing numbers from multiple cells from sheet into just ONE CELL in another sheet. Would you please advise?
Great! How about 2 importrange in once spreadsheet? Thank you Sir!
Thank you so much. This was very helpful
Thanks a lot. I was looking for this