hi,, your explaination is good ... what if we have different set of columns in each subsheet ... and i want selected columns from each sheet with date filtered with last 3 days
This video is helpful. Thank you! But I have a question, what if on the other sheets I want to bring over, I have a specific word like completed in a column, and I don't want that row brought over when the word completed is found. How do I write that into this formula?
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
sir will the query function do column wise copy.for example if there are sheets with names Eng,Maths,Language and Each sheet with column labels test1,test2,test3. i want to pull out the values of test1/test2/test3 of all 3 subjects in a single table based on the drop down list.What is the query to be given. help in this regard
Fantastic. I have a customised sheet that I use to enter mixed data. I do not want to revise the sheet but I want to copy blocks of daily data and consolidate the into into a monthly sheet for analysis. However the data will not be clean because at 3 different rows data is there for another attribute (I want to evaluate weight and these rows captures temperature). The row locations are consistent ( e. g. Rows 7,12,16) how can I delete those rows. Thanks
Thank you for this Chester. it worked overall apart from one row which is weird. When doing this on my file, the first 7 rows of the first sheet I am trying to merge seem to have been concatenated into 1 row into the mastersheet. Is there something that I am not doing correctly?
Thank you! This did exactly what I wanted!! Is it possible to then also filter them by the dates? I have tried using the filter button but all the data just drops down heaps of rows.
I like to ask that whether I can enter data in Master sheet (on columns no included in the query command) for further Data . I have tried but whenever I enter any individual sheet data the data entered in master sheet get mixed up. Any suggestions please
Hi! is there a way to do this backwards? So I have a ton of info in a master sheet and separate sheets that I want them to automatically go into. How do I do that or is there a video?
this worked really well, but I would like to sort the master sheet by date, and it does not allow this, as the data is still grouped in sections (based on sheet they are from). Is there any way around this? could I duplicate the sheet but the data still be live?
Hi bro, love your work just keep doing great. I have a sheet having multiple tabs and among these tabs one is a Master tab in which I want to reflect the whole data of other tabs (till here it's done) but the question is that, is there a possible way for the data(of newly added tab) to be added in Master automatically every time a new tab is added ?? Plz you response would be highly appreciated 🙂
Is there a way to do this using Import Range? In my case, we work with 3rd party companies and I do not necessarily need them seeing each other's info. I am updating the client name and assigned 3rd party on the master sheet and it currently populates each 3rd party's individual workbook. I would like for their input data to in turn automatically populate to my master workbook.
QUERY({ IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); }, "SELECT * WHERE Col1 IS NOT NULL ORDER BY Col12 ASC, Col11 ASC, Col1 ASC") this is what i use if this helps in anyway?
How do I get query to work, when I assign to my salesman.My first sheet is my master,then 2nd sheet is salesman1,3rd sheet is salesman 2. If that makes since. Thanks in advance.
Hi Sir, I have 3 different forms named, Fresh call, Follow up call, Site Vist, All these forms have different questions the common thing is the names of the agent, I want to provide feedback and take signoff from that person on Google sheet itself how do I do it, need your help
What about if the data I wont to bring in is in another document and on multiple tabs in that google sheet? how can we make this happen? i.e. =SORT(IMPORTRANGE("11KjZBSny15TykVlyokntROEvWhTa1AwL4nkrG399rqD","DATA 1!A2:I","11KjZBSny15TykVlyokntROEvWhTa1AwL4nkrG399rqD","DATA 2!A2:I"))
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Never knew you could add multiple sheet references to one query function. Thanks for the Google Sheets wisdom!
Success, I was able to combine from 1 file (with multiples sheets) to another google sheet file. Thank you very much for the tutorial.
Fantastic. Thank you. Some of these videos are difficult to follow but this was very clear and exactly what I needed.
Great to hear!
This is so helpful! But how do you do this in regular excel?
Thanks. You have saved me.
Brilliant!! Thank you so much
This can be improved upon by using SORT. This will combine the data and sort it by date
=SORT({SHEET1!A6:F;SHEET2!A6:F},1,0)
Very helpful and concise. Thank you!
Very helpful. Thanks!
hi,, your explaination is good ... what if we have different set of columns in each subsheet ... and i want selected columns from each sheet with date filtered with last 3 days
thanks for a wonderful video!! Is it possible to do the exact same thing if the data is in multiple workbooks?
This was super helpful. Thank you.
Thanks. Precise and hepful.
This is great, What if we want to sort the master sheet by the rolls by Date or Number ascending/descending is a specific column?
Thanks, great help.
Great video. Thank you! Is there a way to create the formula so it accounts for new sheets I add in? Or do those need to be created in advance?
This video is helpful. Thank you! But I have a question, what if on the other sheets I want to bring over, I have a specific word like completed in a column, and I don't want that row brought over when the word completed is found. How do I write that into this formula?
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
sir will the query function do column wise copy.for example if there are sheets with names Eng,Maths,Language and Each sheet with column labels test1,test2,test3. i want to pull out the values of test1/test2/test3 of all 3 subjects in a single table based on the drop down list.What is the query to be given. help in this regard
Thank you for sharing it..🙂
pls help- query for combining new entry in individual sheets into last row of master sheet
Fantastic. I have a customised sheet that I use to enter mixed data. I do not want to revise the sheet but I want to copy blocks of daily data and consolidate the into into a monthly sheet for analysis. However the data will not be clean because at 3 different rows data is there for another attribute (I want to evaluate weight and these rows captures temperature). The row locations are consistent ( e. g. Rows 7,12,16) how can I delete those rows.
Thanks
perfect, is this trick working in excel as well?
Love it.
What if you have 100 different sheets? Is there a way to select “all sheets” in a formula without having to name them 1 by 1??
can you do this across different workbooks?
Thank you for this Chester. it worked overall apart from one row which is weird. When doing this on my file, the first 7 rows of the first sheet I am trying to merge seem to have been concatenated into 1 row into the mastersheet. Is there something that I am not doing correctly?
Thank you! This did exactly what I wanted!! Is it possible to then also filter them by the dates? I have tried using the filter button but all the data just drops down heaps of rows.
Following up to see if you achieved this? Thanks.
Hello Chester.. This was quite helpful...but getting an error.. "Query returning results into merged cells in Google Sheets
" what to do???
What if I keep adding more sheets to this? Is there a way to prospectively keep adding data from all new sheets made? Or using script?
I get error "In ARRAY_LITERAL, an Array Literal was missing values for one or more rows.
I like to ask that whether I can enter data in Master sheet (on columns no included in the query command) for further Data . I have tried but whenever I enter any individual sheet data the data entered in master sheet get mixed up. Any suggestions please
Hi! is there a way to do this backwards? So I have a ton of info in a master sheet and separate sheets that I want them to automatically go into. How do I do that or is there a video?
Supper but if the headings are different name what will be the merging solution
this worked really well, but I would like to sort the master sheet by date, and it does not allow this, as the data is still grouped in sections (based on sheet they are from). Is there any way around this? could I duplicate the sheet but the data still be live?
Hi bro, love your work just keep doing great. I have a sheet having multiple tabs and among these tabs one is a Master tab in which I want to reflect the whole data of other tabs (till here it's done) but the question is that, is there a possible way for the data(of newly added tab) to be added in Master automatically every time a new tab is added ??
Plz you response would be highly appreciated 🙂
Will this work if the data has checkboxes
Is there a way to do this using Import Range? In my case, we work with 3rd party companies and I do not necessarily need them seeing each other's info. I am updating the client name and assigned 3rd party on the master sheet and it currently populates each 3rd party's individual workbook. I would like for their input data to in turn automatically populate to my master workbook.
QUERY({ IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); IMPORTRANGE("Sheetlink", "Sheetname!B3:M999"); }, "SELECT * WHERE Col1 IS NOT NULL ORDER BY Col12 ASC, Col11 ASC, Col1 ASC") this is what i use if this helps in anyway?
Can you please share the spreadsheet for practice ?
how to insert star in formula after where?
I want the sheet name in it as well
How do I get query to work, when I assign to my salesman.My first sheet is my master,then 2nd sheet is salesman1,3rd sheet is salesman 2. If that makes since. Thanks in advance.
Hi Sir, I have 3 different forms named, Fresh call, Follow up call, Site Vist, All these forms have different questions the common thing is the names of the agent, I want to provide feedback and take signoff from that person on Google sheet itself how do I do it, need your help
What about if the data I wont to bring in is in another document and on multiple tabs in that google sheet? how can we make this happen? i.e. =SORT(IMPORTRANGE("11KjZBSny15TykVlyokntROEvWhTa1AwL4nkrG399rqD","DATA 1!A2:I","11KjZBSny15TykVlyokntROEvWhTa1AwL4nkrG399rqD","DATA 2!A2:I"))
Is there a way to add to the query to make it populate into the master in alphabetical order?
@Kevin Wright Your Great
Very Helpful
how can i include the tab that has space in it's name? the formula doesn't accept it.
Good instructions but my problem is i have put data validation.
Please give us chance to download all videos one time because when trying it give us error
WHEN I ENTER QUERY AND WRITE ("SELECT * WHERE COL1 IS NOT NULL") I COLD NOT FIND ANY RESULT