Thank you!!!, I was banging my head against the wall previously because IMPORTRANGE wasn't working for importing multiple sheets into a single query, you sir are awesome!! thanks again

This entire series is amazingly helpful. It is THE definitive guide to using Sheets like a pro. Thank you!

Your videos are the best. I have been able to build an entire database in multiple sheets because of your awesome tutorials. THANK YOU!

This is amazing and your talent of explaining the steps inspires me!

I don't have enough words to appreciate you putting out all this amazingly explained information for free on KZfaq... Thank you...!!!! Thank you....!!!!! Thank you....!!!

This was so helpful. Literally the only place I found such a clear answer. Great video

Thanks for all your tutoring. Your videos are just what I needed as I needed to brush up on my accounting reporting skills not utilised since I retired years ago. The software environment has changed a lot and the advantages of Google sheets offers as a way of communicating and collaborating is significant. I used to use Visual dBase which had an SQL like query language so the syntax is familiar. What was great about VdB was that you could input data in a user friendly form and see the code come out on a "Command Screen". It was a great way for a novice to write and learn to code. In addition you could copy and paste the code and incorporate into larger programs. Wouldn't it be great if Google Sheets could come up with something similar?

Google should make you an official associate, there is a huge demand for resources for google sheet and your channel is an extremely valuable resource

This is what I have been looking for. Thank you very much. Easy to understand and follow.

Wonderful! I knew there had to be a way to query from multiple sheets, I just didn't know about the bracket for the array.

Thanks for the tutorial on using QUERY with IMPORTRANGE. Really helped me!

Thank you SO much - been having so much trouble sorting text data and this finally solved my problem at work!!

Awesome my main man. Had a bit of panic at first not working but I had forgot the QUERY at the beginning. All great.

Thank you so much! I have been able via your videos to minimize manual updates. Thanks again.

Thank you, this was so helpful!

Greetings from Brazil. I would like to thank you for this serie, it was very helpful

You are a great teacher. These videos are super helpful.

Sir, you are the Best, your videos have contributed too much in me gaining respect in my office

Wow amazed.. thanks again man.

Very clearly explained - thank you!

QUERIES ARE WONDERFUL!! I was wondering how to reference a series of cells from a different worksheet into a series of cells in a different worksheet without copy-pasting a formula a million times. This is the answer. You don't have to type it all out manually, just as expected. Thanks for these tutorials, I looked for google spreadsheet tutorials and this series is what I came across, which is helpful.

Great video, extremely useful! Thanks!

Thank you for your sharing. I learn a lot from this video.

Appreciate the examples!

I’ve searched months and found this great video to solve my problem.

You all are awesome. Thank you for the great videos you create and share!

Wow Brother, thanks for making life Easy

Awesome tutorial! Loved it. Thanks for putting in such efforts to educate folks.

I'm learning new tricks...This tricks also helpful for learning SQL queries..Thank you brad, very concise and clear..

Great demo. Is there a way to retain the formatting from your Master sheet onto your new sheet so it looks like the Master Sheet?

level 40 google sheets! Thank you.

Very useful mate, your video helps me a lots

Thank you so much for this informative video. I have been looking for this for a long time. it solved my biggest problem.

Really good, very clear tutorial

Great tutorials!

great job with your channel, data is king

Great vid... thx. I can't find the limit of the number of tabs you can query with { }. I think I'll have to look at some scripts since my file will keep growing daily with new tabs that will need to be referenced. Thx again.

Thank you so much, exactly what I am looking for 😊👍👍👍

That is an amazing lesson, and you are Talent online teacher.

This is great. Many thanks.

Thank you very much sir. Your video has helped me a lot.....

VERY USEFUL FOR BOTH BEGINNERS AND PROS

Thanks so much for posting this video! any tips on using importrange where the source file has URLs in multiple columns that you would like to show & work in the destination file?

you explain it so well. thank you.

Thank you its really helps me in query function.

Hi, great tutorial. Can this query syntax be used from a script? Have you got some examples to indicate? Thanks

You sir, really gave me a lot of new knowledge, Also I would like to ask you a question related to database, In my case, I have multiple tabs in my spreadsheet, and I combine them into a big database using Query function, now that I have master database using query I'd like to add more column in master database that would also be added in my tabs or my mini databases, The problem is, the database using query function is dynamic, meaning that the data would grow as the data from others tabs increasing, so the column where I wrote in my master database is not valid anymore as the data is changing. Is there anyway how to put the data to follow the dynamic change by the query function? I'm really sorry for my bad english, thank you

Excellent. Well done

Thanks for these videos - they are incredibly helpful. Is there a video to show how to combine data from 2 different sheets where the number of columns and the data is different but what would allow a join is that there is an email id for the records on both sheets. I want to create a sheet that would allow me to select columns from each of the sheets where there is a join for the email id. Is this possible?

Excellent video, thank you!

Hi Thanks for the greate video If want to get data from H and G if text "IL" what is the function

Your video is really amazing. But I have a questions. I'd like to set up on Google Sheet where I can search just typing initials, such as "P" in a cell and them query makes the information in my sheet appear. Such as you've done with Shirt. Could you help with the funcion formula?

very helpful

Wow, the IMPORTRANGE explanation at 9:58 is going to be a game changer!

These video are super helpful as the steps are explained very well. I have tried various formulas to meet what I need and while I can make each formula work on it's own, i'm having trouble finding the right combo. I have two workbooks. I need one workbook to vlookup / match a name in a column that is on another workbook. Example, John Doe appears in Coulmn H in 1 workbook named WRAP. I need the formula to search column B in another workbook Named Assets, to see if that name is true. If it is True, then it should highlight the name in WRAP workbook a color, using conditional formatting. Ideally, once John Doe has been removed from Assets workbook the Wrap workbook will remove the highlight. Sorry for the long comment. Is there another way to submit this. Would love your help!

Thank you!!!! So easy to follow and understand :D

pretty awesome helpful and useful to the highest levelz

Thanks.. it really help very much..

thanks You so much!!

Great video. Thanks so much. Is there anyway to filter/sort each column of imported (importrange) data in the master?

Awesome TUT man

Pure gold!!!

Thanks a lot, great learning..so how I getting this files , its better to practice.

Wow, the subquery part is something I was looking for a long time. Since Google Sheet doesn't offer the "HAVING" SQL clause, this subquery is essentially the substitute for the "HAVING" clause.

Helpful 👍

Thanks for your help

This video solved my biggest problem. Thanks and more power!

if we add rows in both sheets and put query function where these updated data shown and how??

Thanks for the awesome video. How can we overwrite importange spreadsheet data from destination sheet so source sheet data will be changed ?

Thank you!

Awesome!!

Thanks for the information. Super helpful! Is it possible to utilize these, and have the data become static? I'd like to manually add data into my spreadsheet, but I don't want to to be overridden by the importrange data.

What is the boundary limit you mentioned? Could I use 50-60 import ranges for example

This is very fruitful and productive video that I have ever seen on KZfaq. I want to to do the same thing you did but Instead of just taking the same info from sheet 1 to the master list, I need to cut the information form sheet one to sheet two while I apply query. Why I need this and ask you that because I have an Google sheet and there is a column which is just for the status of the projects in which I have pending and completed. So, whenever it is going to be completed in the sheet 1, then I want it to automatically delete the completed project in sheet one and transfer it to the master list. I will appreciate that if you can help me in this regard, not only me need this but all most all of us need to have it. A huge thnx for you and your amazing and productive videos. Best KZfaq channel ever.

I'm running into the same problem. "At 18:49-18:50 in the video, there is an error message that pops up saying "In ARRAY_LITERAL, an Array was missing values for one or more rows." Are you able to explain what that means, and how to fix it?"

Ty for this video GOD BLESS U😊

thank you , for great sharing

Great Presentations. Would you share the sheets data so we can practice?

!!!! I used importrange function to copy a range from one sheet to another and I made some column in that sheet which were filled manually. how can i fix the manually/static filled data with the automatic/dynamic filled data?

ThanQ alot 😘

Can we apply query in this way for 10 sheets, like you have done it for two sheets right likewise can we do it for 10 sheets in the same way

Genius...

thanks you so much

Hi there, seems excellent and what I need but it doesn't work for me as my "IL" criteria is more diverse.. I need to look within the celle for one word (people answered paragraphs) can we please exchange on this issue? that would be very kind . Dave

I appreciate all the videos that your team share. I hope you could help me with this or point me in the right direction. I use Google Forms to get some information, The database is Google sheet document that google forms create, then I use IMPORTRANGE and VLOCKUP to use the data in a presentable Dashboard, but (this is the complicated part) I want to add information from the dashboard to the database and re-write the Cell where the "Comments" are. The cell after the new input will be: Comments 1 + Comments 2 + New added comments... HELP

Hey, I have a simple database from generated using google forms, I sorted the data according to query function into another sheet, but now I want to make another dynamic sheet based with subquery sort as per date, tried everything, but not working... please help

While pulling data from another spreadsheet with multiple tabs, can I specify the number of the tab instead of the name of the tab in the importance function? Basically, the source sheet from where I need to pull data from will have multiple tabs but I want to keep the first tab as the default source of the data, no matter what the name of the tab is. Data needs to be pulled from just one specific cell, say A1.

Good evening, First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it. I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible? Thanks in advance!

This is soon helpful! Any chance you can advise how to bring the formatting over from the other sheets as well? I have some subheads in rows that are supposed to be italic or bold, and they seem to not transfer over. Instead the master sheet uses the formatting that I apply to the master sheet specifically, which would work... except that formatting stays in place while the data gets moved around based on the other sheets. Thank you!

How do I IMPORTRANGE (with formatation) in a way that when I edit the Sheet I've imported it will refresh automatically at the new Sheet? Thank you!

When i try this, it only partly works, it doesn't seem to sort through all the data points i filter.

If pulling from another URL, should it still be A2:H or can it be A1:H? Thanks for the great videos.

@ExcelGoogleSheets What if I have it more dynamic, referencing each of the importrange in 4 cells, one each. If one is blank (as it may be), is there a way to handle the error (similar to what iferror does)? My sheet still imports the same data (or behaves funny) when I delete one of the ranges... thanks for the help! Your videos are always very good and didactic!

Fantastic! Quick question, what If i want the query for more than one option. So in your example I want to show for IL and CA at the same time. How would you do that?

Thanks, with the query how do we add the TAB "name" to each row so we know which TAB the match came from

how can sort the data on the other sheet if i'm using query

I like the way you teach about google sheet and its functions, please help me to pulldata from one google sheet to other tik by tik

Is it possible to filter both IL & CA at the same time during query and importrange?

with the importrange query.. i want to use formula " select B,C,D WHERE B= " CELL REFERENCE FROM CURRENT SHEET "... HOW DO I DO THAT ?

Is there a way to QUERY from a sheet whenever the word "HOME" appears? This would appear in multiple columns and rows.