THANK YOU! I created several sheets (with Date/Time macro & Vlookup student info) for scanner stations to scan High School and Middle School student id's (barcodes) as they come to school, then your ImportRange and Query functions helped me establish a Master Sheet for a full attendance listing. - you made a secondary school secretary's job much easier. I'm a subscriber now :)
I am tired of comment bad on TH-cam, Coz most youtubers have no idea how to solve actual problem of viewer. But hats off to this man. Amazing knowledge and very nice Video. Thank for it.
Where have you been all my day today? Been struggling with this all day and you literally solved it for me within minutes. I've spent hours watching unhelpful videos in every language under the sun (smh). Thanks man.
This was exactly what I needed! I was able to use your tutorial and combine it with a previous trick I learned to get data and display it in the order I needed. Now it will take me seconds to update info each week rather than half a day!
I really like your tone and flow of your voice, makes understanding the process easier... not boring, yet had my attention. Can you show how to use Vlookup up and how to compare two lists and update the new data from another into one updated sheet. I see a lot of simplified Vlookup up, yet in the real world... I find myself doing things the long way and realizing when i'm almost done that I could of done it easier and quicker!
I landed here after watching some of your budgeting videos. You get right to the point, explain things well, and make it easy to follow along. I have no idea how I might use this, but I thought it would be useful to know about the functionality of the query function since you use it in those other video. Thank you so much for helping us work smarter not harder.
This is probably, if not the most, useful google sheets tool that I'll be using from now on for report-building. Somehow, managers don't love pivot-table based reports. So this is a pretty handy idea when combined with the "unique" function to bring rows from a flatfile and process accounting reports.
This is excellent. I watched the first few minutes and found exactly what I needed to do to track changes in payments for items I am trying to get paid off. My brain was thinking about ranges and dynamic links, and not sure where to start, but this was so much easier! Now I can enter the payment in my check register tab and won't have to adjust the payment in my loan tracking tab each time I make an additional payment or change the amount. Thank you!
Excellent video, and the way you progressively laid out the steps so that they built on the preceding knowledge of the last step was masterful. Great teaching method. Extremely helpful!
I'm trying to teach myself Google sheets but I think this was way above my head. I might have to come back to it down the road when I get to that level. But I will subscribe to your channel, you have great other videos that I can currently learn from.
Great tutorial! Your delivery is direct and relaxed at the same time. I came looking for an importrange refresher and you covered the importrange/query combo which I'd not previously done. I'm a big fan of using the Where parameter in the query to get rid of those blanks rows instead of specifying a range in the import function. That way you're covered if there are any changes in the imported data sets.
I am building a timelog and billing application for my niece's service based business, it will build client invoices and payroll estimates. What I've learned here will enhance the program. Thank you.
That’s impressive. I have a soccer ranking table, and as it’s dynamic as each team moves up or down according to their wins/loses/draws. Will *query* be my ally if I want to sort each’s team points on a column or row after watch match for the season the dynamic ranking table on page 1? Or is there another filter be better? Thanks in advance
Thank you very much! This is very helpful. I was able to resolved my concern. Can you use this if the data that I will import comes from a merged cells?
Hi, Thanks for the import range function specifically, I'm looking to put script with trigger in master file and take input via another file with people having edit access to prevent copying. I was worrying about how powerful and frequent is import range? Does it require me to open file to update the changes? I'm looking for data of not more than 30 row by 15 columns
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!
A great video this is! Just want to ask whether it is possible to make import range more dynamic by importing only certain rows if only that rows contain certain data ?
Great Video. I want to import rows from multiple sheets to a summary sheet, but do not know how many rows will be in each sheet as they are developed. Is there some way you can write into the formula to only import rows (or parts of rows) that have data in them? need to avoid all of those blank rows in the summary sheet. Hope this makes sense. Thanks.
Thanks for the video! Question... Once you have everything imported and you make a change to the 2019 and/or 2020 spreadsheet will the change show up in the master sheet? Thanks again!
Thanks for the great video! I am wondering if you know a way or command to import the entire content of a tab, with the same original formatting & formulas maintained, without using the manual process of "right click > Copy to > ..." Using Record Macro option I would like to "design" a button in my sheet that, when pressed, it would automatically generate a new tab with the content being identical to an external master spreadsheet, but using "Importrange" brings over only the "values" of the original sheet cells (i.e. no formatting, no formulas, etc.)
Good tutorial, thanks! Is there a way to query dynamically from an imported list of URL's vs going to cut and paste from each source worksheet that needs to be queried? I have a script that imports the URLs of reports generated in a given year. Can that list of URLs be queried dynamically to obtain information from the same sheet in each worksheet? Thanks in advance.
I appreciate your excellent delivery of information, thank you. This video was very helpful in introducing me to queries. It also helped me with importrange. I do however still have a need to find a solution for vlookup for multiple worksheet-tabs inside a different sheet. The option to combine tabs into one isn't quite suitable and so I will continue searching for an answer, it is possible I will go with your combine option if i cant find something else since it would likely work. Thanks for an excellent video, you made it very clear and easy to remember.
Dude, this was the best google docs tutorial I've ever seen. I'm making some SICK accounting spreadsheet...!!!!!!!
Awesome
THANK YOU! I created several sheets (with Date/Time macro & Vlookup student info) for scanner stations to scan High School and Middle School student id's (barcodes) as they come to school, then your ImportRange and Query functions helped me establish a Master Sheet for a full attendance listing. - you made a secondary school secretary's job much easier. I'm a subscriber now :)
This makes me so happy! It’s why I do it! Sorry for the delay in response!
I am tired of comment bad on TH-cam, Coz most youtubers have no idea how to solve actual problem of viewer. But hats off to this man. Amazing knowledge and very nice Video.
Thank for it.
Where have you been all my day today? Been struggling with this all day and you literally solved it for me within minutes. I've spent hours watching unhelpful videos in every language under the sun (smh). Thanks man.
I have been looking for 2 days for this exact information! Thank you so much! This is a huge help!!!!
Awesome!
This was exactly what I needed! I was able to use your tutorial and combine it with a previous trick I learned to get data and display it in the order I needed. Now it will take me seconds to update info each week rather than half a day!
I really like your tone and flow of your voice, makes understanding the process easier... not boring, yet had my attention. Can you show how to use Vlookup up and how to compare two lists and update the new data from another into one updated sheet. I see a lot of simplified Vlookup up, yet in the real world... I find myself doing things the long way and realizing when i'm almost done that I could of done it easier and quicker!
Couldn't hit subscribe quick enough! Great tutorial!
I landed here after watching some of your budgeting videos. You get right to the point, explain things well, and make it easy to follow along. I have no idea how I might use this, but I thought it would be useful to know about the functionality of the query function since you use it in those other video. Thank you so much for helping us work smarter not harder.
This is probably, if not the most, useful google sheets tool that I'll be using from now on for report-building. Somehow, managers don't love pivot-table based reports. So this is a pretty handy idea when combined with the "unique" function to bring rows from a flatfile and process accounting reports.
This was absolutely amazing and well explained in a way I haven't seen (or heard) before 👍🏼👍🏼 great job!!! 👏🏼👏🏼
I'm making an inventory management spreadsheet. Your tutorial has helped me a lot, thank you! Keep it up!!
Very coool!!!!!!! and you explained it very clearly. Im gonna start using IMPORTRANGE right away! Thank you!
Brilliant! This was so helpful for combing data from multiple sheets.
Thank you, it helped me alot. God bless ya. Love from Bhutan
This is excellent. I watched the first few minutes and found exactly what I needed to do to track changes in payments for items I am trying to get paid off. My brain was thinking about ranges and dynamic links, and not sure where to start, but this was so much easier! Now I can enter the payment in my check register tab and won't have to adjust the payment in my loan tracking tab each time I make an additional payment or change the amount. Thank you!
Excellent video, and the way you progressively laid out the steps so that they built on the preceding knowledge of the last step was masterful. Great teaching method. Extremely helpful!
exactly what is needed in the world of spreadsheets TY!
Just start learning about all formulas. This contents is very helpful. Still have room to growth💪🏽. Going for more.
I'm trying to teach myself Google sheets but I think this was way above my head. I might have to come back to it down the road when I get to that level. But I will subscribe to your channel, you have great other videos that I can currently learn from.
Great tutorial! Your delivery is direct and relaxed at the same time. I came looking for an importrange refresher and you covered the importrange/query combo which I'd not previously done. I'm a big fan of using the Where parameter in the query to get rid of those blanks rows instead of specifying a range in the import function. That way you're covered if there are any changes in the imported data sets.
Thank you for simply this formula👍👍 Good job.
Excellent Tutorial on both Query and importrange, Thanks :)
Awsome man you have actually saved my time.. God bless you❤
This was right at my level. Thank you!
Loved this explanation! It was easy to follow! Please keep them coming!
Great information easy to understand as it was clearly explained. This will be useful for me to use.
I wathced several videos and yours is giving the best info for me today.
Thanks
Awesome glad to hear
Thanks a lot! Great tutorial, really solved my needs :)
Very good video! A solid cornerstone for further development!
hey, thanks for this. i'm doing a trial run for a job application and this is helpful.
Thank you! After hours of looking around, this is what I needed!
Thanks for sharing your knowledge, and helping me Work Smarter Not Harder
I am building a timelog and billing application for my niece's service based business, it will build client invoices and payroll estimates. What I've learned here will enhance the program. Thank you.
Love hearing it!
This was tremendously helpful. In addition to the value of the content, your manner and way of explaining is concise and relevant. Thanks for this!
Thank you, I was looking for these exact formulas!
Great job! Very helpful! Good luck!
I definitely learned something from the video.
Thank you
It's very helpful
Save my time
Very helpful. I really love it. Thank you
Simple and clear explanation. Sweet
Amazing video. Thanks from Bangladesh.
Great video! Thank you for the information
Great work. I was trying the same thing without success. Thanks for the video.
This was great! Easy to follow. I will be referring back to this! Subscribed!
Very useful video! Thanks!
Superb explanation and demo of both QUERY and IMPORTRANGE functions. Appreciated!
Brilliant video man. Loved it!!
Your awesome thank you for sharing your knowledge 🤓😎
Good stuff my man! Basically my data teacher here.
Thanks a bunch!
Thanks alot for your great great explanation
You explained this very well and clear. You're a great teacher... Thank you for this video
Wow! Thanks for the kind words!!
Awesome tutorial!
That’s impressive. I have a soccer ranking table, and as it’s dynamic as each team moves up or down according to their wins/loses/draws. Will *query* be my ally if I want to sort each’s team points on a column or row after watch match for the season the dynamic ranking table on page 1? Or is there another filter be better? Thanks in advance
Thank you! very clear explanation.
Excellent job - I was specifically looking for a concise method for the import range function. Thank you!
Great vid! Excited to apply this at work 😊
Thank you! I got the data I wanted to because of your easy steps guide.
Exactly what I needed! Thank you! Subscribed and watching other videos now!
Awesome to hear! Let me know if you have any questions!
Amazing details! Thank you!
This video was very helpful thank you
very good tutorial my friend, thanks!
Merci , ce tips m'est très utile !!
Thank you very much! This is very helpful. I was able to resolved my concern. Can you use this if the data that I will import comes from a merged cells?
Worked well for me Thank You!!
Thank you for this video! This is just exactly what I want to know.
Hi, Thanks for the import range function specifically,
I'm looking to put script with trigger in master file and take input via another file with people having edit access to prevent copying. I was worrying about how powerful and frequent is import range? Does it require me to open file to update the changes? I'm looking for data of not more than 30 row by 15 columns
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!
Thank you for this! Helped me out massively 🙂
A great video this is! Just want to ask whether it is possible to make import range more dynamic by importing only certain rows if only that rows contain certain data ?
Great Video. I want to import rows from multiple sheets to a summary sheet, but do not know how many rows will be in each sheet as they are developed. Is there some way you can write into the formula to only import rows (or parts of rows) that have data in them? need to avoid all of those blank rows in the summary sheet. Hope this makes sense. Thanks.
This video is amazing, thank you for taking the time to explain!
Its very helpfull Thank you so much🤝🙌
Love hearing it! Thank you!
Thank you I was looking for adding two or more importranges as one is not enough when you have huge data 50k+ rows
great lesson! i want to create dynamic atendants lists to diff workshops and days based on bookings
Thanks for the video! Question... Once you have everything imported and you make a change to the 2019 and/or 2020 spreadsheet will the change show up in the master sheet? Thanks again!
You're a great teacher! Thank you for your time invested to help us all :)
This is awesome Bro.
I worked with these two functions but never did I joined two ranges from different sheets in 1. Good stuff !
Super easy to understand
Thanks for the great video. Quick question, why do we add a 1 in the last query you wrote?
Thank you! I'm going to use this to create a budget for the League of Women Voters in my area.
Amazing video! huge help thanks
Great Video. Thank you
This video is awesome!
Learned a ton!
Thank you. other tutorials left me short of successfully using importrange fn. Now I can do it.
Awesome! That’s why I do what I do.
Thanks for the great video! I am wondering if you know a way or command to import the entire content of a tab, with the same original formatting & formulas maintained, without using the manual process of "right click > Copy to > ..." Using Record Macro option I would like to "design" a button in my sheet that, when pressed, it would automatically generate a new tab with the content being identical to an external master spreadsheet, but using "Importrange" brings over only the "values" of the original sheet cells (i.e. no formatting, no formulas, etc.)
Good tutorial, thanks! Is there a way to query dynamically from an imported list of URL's vs going to cut and paste from each source worksheet that needs to be queried? I have a script that imports the URLs of reports generated in a given year. Can that list of URLs be queried dynamically to obtain information from the same sheet in each worksheet? Thanks in advance.
Great tutorial.
Thanks for this awesome guide!
Awesome Vid. Make some full course on Excel power query and Google Sheets Query Functions.
Informative ❤️
I appreciate your excellent delivery of information, thank you. This video was very helpful in introducing me to queries. It also helped me with importrange. I do however still have a need to find a solution for vlookup for multiple worksheet-tabs inside a different sheet. The option to combine tabs into one isn't quite suitable and so I will continue searching for an answer, it is possible I will go with your combine option if i cant find something else since it would likely work. Thanks for an excellent video, you made it very clear and easy to remember.
Great Tutorial. Good job.
Great job 🎉
Great video, thanks!
Great vid! Thanks 😊
Such a relaxing voice 🙂
Thanks for your help!