I'll be releasing a full scale paid dashboard course soon! Signup if you want early access (will be limited to x amount of students): forms.gle/iPPQtHjP4GF6ukgAA
This is exactly what I needed. I am starting my own business and wanted to make sure I was tracking my expense and invoices properly. I have a monthly spreadsheet for both invoicing and expenses but wanted to be able to have a YES (Year End Summary) tab I can see where money is flowing through my business. I think this will help keep the books clean and accurate. Less margin of error while entering data. Love tha your tutorials are easy to understand and informative. Keep up the great job will be visiting your channel more often. Wish you all the best!
Great Job! Love the fact that you went right to the point and explained fast and simple... Im new to sheets and I'm working on a personal project to start my own business and i will have maybe more than 40 sheets.. this will help me a lot to study, will look after your channel for more tutorials.. Thanks
Perfect! This is exactly what I was looking for. I've been using excel to do monthly home expenditure spreadsheets, then combining all the totals by category at the end of the year. This gives me my rough budget for the following year. It takes a lot of time. This will make it really easy by using tabs then combining all the tabs into one spreadsheet. Thanks!
Everybodddyyyy--this tutorial works. I used this formula to track my 3 goal sheets and combined to one master sheet. I had a small error. Emailed Michael. I got his response same day. Fixed my error by his instruction. THANK YOUUUU!!!
This is exactly what I needed to learn! I appreciate your detailed instruction. I wanted to create a weekly account activity report. You have saved me Hours!! Thank you!
Extremely helpful! I'm going to use this for most of my spreadsheets now! Is there another function you can add to the master sheet so that it automatically sorts the information by date and time?
Excellent. I will use this immediately for a super intricate spreadsheet I'm working on. You actually solved at least two issues that have been racking my brain.
#Solution! Problem I encountered: All the data of a certain range of rows was put into one row and grouped into the cells of that one row. In order to separate that, I used on Sheet 1 (my dashboard) the following formula. The extra zero was needed. =query ({'Sheet2'!A31:H; 'Sheet3'!A30:H; 'Sheet4'!A30:H; 'Sheet5'!A31:H}, "select * where Col1 contains 1", 0) The video helped me! Thank you.
Is there a way for this to work if you add a new tab and it will then include it in the summary tab? In excel, if you place data between the first and last tab, it will keep consolidating it without having to add it to the formula. Trying to understand if Sheets has this ability. Thanks
hi thanks for this very informative this is what i am looking for. .really help. . just want to ask too if there is chance that we can sort the queried data according to date? thank you in advance
I used exactly your formula but it printed all data of 1st sheet in first line , data from 2nd sheet seem correct but nothing updated when I input new data, If I only select data from 1st and 2nd sheet not using querry, it'll show correct result. please help
I used your exact formula and was returned with "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: col1". Yes, I made sure my references were correct.
When the position of a cell changes (for example, a row is added so that B4 is now B5), the new cell position is not updated in the sheet with which that cell is synced. How to resolve?
Thank you for this video and it helps. I would like to combine all the tabs into one master tab but have unique customers based on ID in Column 1, but aggregate the totals for all the sheets for Column 3. Using your video I was able to pull in all the records for all of the tabs, but I can't figure out how to aggregate the totals. I assume it would need a SUMIF criteria or use a SUM function in the query but need help with the syntax. Could you help or do a video on that? Column structure is Column 1 is ID, Column 2 is Names, and Column 3 are monthly purchases.
yeah that is a really cool feature of google sheets...the query function...are range names expandable if you add rows or do you have to reset the range names every time you add a new row of data...seems like that might work too...
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 🙂
Wow thank you. Your presentation was so clear even for a total nubie like me! Can ask a question?- Is the data sortable in the Master sheet? I'm using mine for food inventory
im doing exactly what youre doing here and having an issue where it is transposing the data instead of making it all go downwards; it goes left to right... why is this happening?
Absolutely excellent tutorial. I've been wanting to do a sheet that need this for years. Wicked my General!!!! Now if you can do a tutorial that shows how to enter data in says cell B2 that when enter is pressed the data moves to the cell below (B3) and when new data is entered into cell B2 the process is repeated moving the new data into cell B3 and the previous data from B3 to B4. The process should be able to be repeated with the oldest data descending from B3 and the newest data in B3. Now if you can do that then you are walking on water as far as I am concerned. 😁
What about going from a Master TAB to fill other tabs - I want to plug data into 1 master tab and this data feeds to the correct tab - I will have 1 column on the master tab with a text name that will match where that data should go / matching tab -
Do you plan on editing the data in the newly created tabs? You can’t edit those new tabs - you can only add extra columns with formulas to create calculations etc. If you want to fill data from a master tab to other tabs, and then edit that data, you’ll need to use Apps Script. Otherwise, I would probably just use the QUERY formula to move the data (again, if you only want to view the data in the new tabs)
Hi I have a question I have multiple sheets say , of a bill of quantities summary, preliminary, bills materials, manpower, equipment, manpower productivity, equipment productivity,manpower wages , equipment prices, quantities calculation sheet all these are sheets . I want to have all these sheets as tabs on the display sheet of excel, the to input data, you must have project details, enter the drawings on the next step. Then start quantity calculation all the sheets have to be linked so that when you click on generate reports material schedule it brings categories .
This is so helpful! How do I then sort the Master Sheet by different columns after this is created? When I try to sort, it doesn't sort correctly. Thank you!
You can't sort with a filter or anything. You need to add an "ORDER BY A ASC" or "ORDER BY B DESC" depending on the column you want to sort by. ORDER goes after GROUP BY
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..
IS there a way to add the data at the end of the data set v in the middle. We are using for lead tracking and need it to follow filter based on date entered
Hey Michael. Great vid. Thank you. Quick question. How would you include another column which would display the Tab name. For example, if you replaced the tab names with a "State" name eg "NSW" or "QLD" or "VIC", thereby adding a new column in the summary tab called "State", that would show the corresponding state to each record. Hope this makes sence :)
Sir, my third column consists alphanumeric anfr numeric data, but the master sheet is capturing numeric values only how to resolve this issue kindly advise
Hi Michael is there anyway to do the opposite where Input data in one master sheet and the data automatically fills in corresponding sub sheet !! Thanx in advance!!!
Hi, this is awesome thanks for this! Just wanna ask if there's a way to just put all the months into "dropdown" so I can just select a month and will show me all the data from it without showing all the months and data together. Hope this makes sense. Thanks in advance!😊
What if I have data in two tabs in our case: Website URLS, But need the Email data from the 2nd tab to come over and match the Url in the main tab. How would we do that if the URLS are scrambled on the main tab in its Website URL column?
This is super useful thanks! I'm using this to show weekly performance for clients into one sheet. The query works well and brings only the 2nd row of each client sheet so that every week, I can see performance for this specific week for all clients. However, whenever I add a new row for the new week on the client sheets, the formula automatically moves to the 3rd row instead of staying in the 2nd row. Any idea how I could ensure it only takes the 2nd row? I've used the dollar sign but it doesn't work. I also saw INDIRECT and OFFSET formulas online but couldn't make it work (I think it's because I'm using a range rather than a specific cell).
what doing the opposite like" Combine cash Book" where you type information onto the home page and it automatically appear on the ,months sheets instead, please let me know.
Thank you so much , but I have one question , When I add data at sheet 1, I dont want this data I added appear between 2 sheet combined, I want this data I added appearing the next row in big sheet
This is nice, but what I really need is the opposite. I need to auto fill data from master sheet to individual sheet. I have 10 customers and as I fill in the monthly sales data, I want the data to auto fill to each individual customer sheet. Is there a formula for this. Thanks
Hi, i am unable to copy data from one sheet and paste into another like you did, if i use { then a error pops up, which doesnt let me continue. Please suggest
Thanks so much for this, it's really well explained! :) I wanted to ask, how about when I have data validation set up in my multiple sheets and I want to have them all appear in one master sheet? I keep getting errors when I use this formula, and I think it's because I have data validations set up.
I think you're asking how to have one source for your dropdown menu options and then use this source for all of the sub-sheets? You want to create the sheet (Dropdown Menus) with the dropdown menu options on the master sheet. Then you import the Dropdown Menus tab into each of your sub-sheets. And you'll use this imported tab as the data validation source.
I have one large master sheet and want to copy data to a different work sheet with multiple tabs how? Ex. Master sheet has a column with multiple store names. The other sheet is a sheet with stores as tabs. I want to copy data form master using store names to the appropriate tab on the other worksheet. Think it is the importrange but not sure how to filter it for each tab.
thanks,. I do have a question. What if you wanted to have just one master sheet but all the other sheets would draw down from the master sheet. For example, if you have 100 units of X, and 15 different sheets, if 1 was entered in all the sheets it would draw down from the 100 units where the master sheet is. So it would reflect 85 units of X
I'm not a coder but I have the first part done and it works as described, with large gap between tab groups on the master sheet. When I enter the query commands I get an error! I notice you don't mention spaces between commands, ie- select (space) * (space) where (space) col1, etc. But I've tried it with and without spaces and get error. Feels like I'm so close! I'm using this to do materials lists that I can send out on one master sheet for pricing. The lists are broken down into construction phases (doing a porch with roof- so one tab is all for deck construction, another for roof, another for trim work, etc. Thanks for offering this and any suggestions are appreciated!
@@openhand7502 Hey! The only reason I did that is to make it easier to see where I was trying to highlight in the month tabs. You can start the formula anywhere you like.
I got it to work! I capitalized "Col" and it's all working. This is a huge help for what I'm doing. I see I'm one of only a few subscribers to a new channel? I want to send my encouragement- this was a top notch tutorial @@hustlesheets
@@openhand7502 awesome! I'll make sure to add an annotation to the video capitalize "Col1". Thank you!! I'm going to have a lot more videos on the query formula coming out!
Very helpful, Michael! How can I add info from only certain columns together. I.E. I am tracking student attendance and need to see how many days they're missing for the year. I have a sheet for each month that tracks different info, but I want to have a cumulative form that tells me only how many days total they are missing for the year. Can you give me any advice?
Hey dude, do you know how to also copy over the color on color coded cells? I have the master sheet working but we color code certain things as they happen. This does not transfer over to the master sheet although the data itself does. TIA
oh yea thats not going work.. a workaround can be having a column for this... so lets say green = good and red = bad have a column called Status, and then have the same formula that codes it red or green as in your conditional formatting, except make it say "Good" or "Bad" then when this column is imported, make a conditional formatting based on this column lmk if this makes sense or if you want me to do a video on it
Hey, this has been working succesfully for merging data sheets but not for dates. For example when I do =(2018!B2:B440) which are hospital names it perfectly pastes but when I did the same function for a column that has dates like 2018/01/01 it pastes random numbers
I'll be releasing a full scale paid dashboard course soon! Signup if you want early access (will be limited to x amount of students): forms.gle/iPPQtHjP4GF6ukgAA
literally I have just binge watched all of your videos. You've thought of EVERYTHING. Love love love this channel!!!
This is exactly what I needed. I am starting my own business and wanted to make sure I was tracking my expense and invoices properly. I have a monthly spreadsheet for both invoicing and expenses but wanted to be able to have a YES (Year End Summary) tab I can see where money is flowing through my business. I think this will help keep the books clean and accurate. Less margin of error while entering data. Love tha your tutorials are easy to understand and informative. Keep up the great job will be visiting your channel more often. Wish you all the best!
Great Job! Love the fact that you went right to the point and explained fast and simple... Im new to sheets and I'm working on a personal project to start my own business and i will have maybe more than 40 sheets.. this will help me a lot to study, will look after your channel for more tutorials.. Thanks
Thanks Juan!
Perfect! This is exactly what I was looking for. I've been using excel to do monthly home expenditure spreadsheets, then combining all the totals by category at the end of the year. This gives me my rough budget for the following year. It takes a lot of time. This will make it really easy by using tabs then combining all the tabs into one spreadsheet. Thanks!
Everybodddyyyy--this tutorial works. I used this formula to track my 3 goal sheets and combined to one master sheet. I had a small error. Emailed Michael. I got his response same day. Fixed my error by his instruction. THANK YOUUUU!!!
Can you tell us what Error was fixed? Since if we all decide to do this we may run into the same thing.
I was searching for how to manipulate data from multiple sheets, this gave me the basic idea. Thanks!
This is exactly what I needed to learn! I appreciate your detailed instruction. I wanted to create a weekly account activity report. You have saved me Hours!! Thank you!
Thanks man. The little query details at 3:27 saved me days of work. keep up the good videos.
Exactly what I need for now and most important of all, you make it so simple and easy. Best teaching! THANKS for selfless sharing!!!
Extremely helpful! I'm going to use this for most of my spreadsheets now! Is there another function you can add to the master sheet so that it automatically sorts the information by date and time?
Excellent. I will use this immediately for a super intricate spreadsheet I'm working on. You actually solved at least two issues that have been racking my brain.
#Solution! Problem I encountered: All the data of a certain range of rows was put into one row and grouped into the cells of that one row. In order to separate that, I used on Sheet 1 (my dashboard) the following formula. The extra zero was needed.
=query ({'Sheet2'!A31:H; 'Sheet3'!A30:H; 'Sheet4'!A30:H; 'Sheet5'!A31:H}, "select * where Col1 contains 1", 0)
The video helped me! Thank you.
Thanks. If new sheets are being created daily then how to add the data of new sheets to the master sheet automatically?
Thank you for this information! Very fast and clear with a fantastic example!
Is there a way for this to work if you add a new tab and it will then include it in the summary tab? In excel, if you place data between the first and last tab, it will keep consolidating it without having to add it to the formula. Trying to understand if Sheets has this ability. Thanks
hi thanks for this very informative this is what i am looking for. .really help. . just want to ask too if there is chance that we can sort the queried data according to date? thank you in advance
This video might answer your question: ruclips.net/video/DlX8QnZwqcI/видео.html
I used exactly your formula but it printed all data of 1st sheet in first line , data from 2nd sheet seem correct but nothing updated when I input new data,
If I only select data from 1st and 2nd sheet not using querry, it'll show correct result.
please help
This was the tutorial I was looking for. It was tremendously helpful. Thank you so much!
Best explanation of blending data ever
I used your exact formula and was returned with "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: col1". Yes, I made sure my references were correct.
Hey Gene, fill free to make a copy of your sheet and post the link to edit here, I can take a look
@@hustlesheets Haven't posted any spreadsheets before. Do you mean simply post a link in a reply here? Thanks
here is the link docs.google.com/spreadsheets/d/1i07mdVNxnb4SxASJIoM_oVZljlr9b7oyzs5U2t5mjAo/edit?usp=sharing
@@genegraves3076 yes, just go to share in the top right corner and switch it to edit, then post the link here
@@hustlesheets Thank you. Just did that
Thank you Michael, your sharing is really help and I am always waiting for your new videos. I wish you all the best. Good job man.
When the position of a cell changes (for example, a row is added so that B4 is now B5), the new cell position is not updated in the sheet with which that cell is synced. How to resolve?
Thanks! Is there a way to combine data from all tabs in one sheet? I have a sheet that gets data from forms and each form adds data to a new tab.
This is EXACTLY what I was looking for!!
Thank you for this video and it helps. I would like to combine all the tabs into one master tab but have unique customers based on ID in Column 1, but aggregate the totals for all the sheets for Column 3. Using your video I was able to pull in all the records for all of the tabs, but I can't figure out how to aggregate the totals. I assume it would need a SUMIF criteria or use a SUM function in the query but need help with the syntax. Could you help or do a video on that?
Column structure is Column 1 is ID, Column 2 is Names, and Column 3 are monthly purchases.
Thanks a ton! Exactly what I was looking for.
THANKS SO MUCH, I DID IT AND IT WORKS BUT I NEED TO KNOW IF IS THERE A WAY TO SORT THE DATA THAT IS SENT TO THE MASTER SHEET
best google sheet tutorials.
since long I was looking for the same. Thank you so much
thx. great learning is it possible to combine dependent google form information in one google sheet
Fools out there with millions of likes, and you sir are going intelligent goodness. Thanks
Thanks Anthony! Appreciate the support!
Assuming that this is for Google sheets, how does this compare to Excel?
Thanks for the formula. Keep up the good work bro.
Thanks Hariyanto!
Fantastic. Thanks for getting clear and concise. Liked and subscribed.
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?
This was very helpful but... How do I search that first Column for a specific word or "Month" to go with your video?
This is super helpful!! Thank you so much!
Awesome. Is it possible to combine different data from different sheets?
Thank you. Well explained. Now I have better management of our data.
yeah that is a really cool feature of google sheets...the query function...are range names expandable if you add rows or do you have to reset the range names every time you add a new row of data...seems like that might work too...
doesn't seem like google sheets have table name feature for expandable ranges when adding new records
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 🙂
Hi, . Very useful tip.
Is there any way to do the same but dinamícally for X sheets?
I have almost 150 sheets to be merged.
Wow thank you. Your presentation was so clear even for a total nubie like me! Can ask a question?- Is the data sortable in the Master sheet? I'm using mine for food inventory
im doing exactly what youre doing here and having an issue where it is transposing the data instead of making it all go downwards; it goes left to right... why is this happening?
Its happening to me, too. Did u find the answer?
If you add another month, you need to update the formula again? Is there a way to automate the new sheet addition?
Absolutely excellent tutorial. I've been wanting to do a sheet that need this for years. Wicked my General!!!!
Now if you can do a tutorial that shows how to enter data in says cell B2 that when enter is pressed the data moves to the cell below (B3) and when new data is entered into cell B2 the process is repeated moving the new data into cell B3 and the previous data from B3 to B4. The process should be able to be repeated with the oldest data descending from B3 and the newest data in B3. Now if you can do that then you are walking on water as far as I am concerned. 😁
What about going from a Master TAB to fill other tabs - I want to plug data into 1 master tab and this data feeds to the correct tab - I will have 1 column on the master tab with a text name that will match where that data should go / matching tab -
Do you plan on editing the data in the newly created tabs? You can’t edit those new tabs - you can only add extra columns with formulas to create calculations etc.
If you want to fill data from a master tab to other tabs, and then edit that data, you’ll need to use Apps Script.
Otherwise, I would probably just use the QUERY formula to move the data (again, if you only want to view the data in the new tabs)
Hi I have a question I have multiple sheets say , of a bill of quantities summary, preliminary, bills materials, manpower, equipment, manpower productivity, equipment productivity,manpower wages , equipment prices, quantities calculation sheet all these are sheets . I want to have all these sheets as tabs on the display sheet of excel, the to input data, you must have project details, enter the drawings on the next step. Then start quantity calculation all the sheets have to be linked so that when you click on generate reports material schedule it brings categories .
This is so helpful! How do I then sort the Master Sheet by different columns after this is created? When I try to sort, it doesn't sort correctly. Thank you!
You can't sort with a filter or anything. You need to add an "ORDER BY A ASC" or "ORDER BY B DESC" depending on the column you want to sort by. ORDER goes after GROUP BY
Which better use this query or filter function? i use the filter but sometime my formula will be broken
How do you do it the other way around? If I have one master sheet and I want to divide the information in different tabs? Thank you!
Exactly what I need to do! Very helpful
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..
IS there a way to add the data at the end of the data set v in the middle. We are using for lead tracking and need it to follow filter based on date entered
Hey Michael. Great vid. Thank you.
Quick question. How would you include another column which would display the Tab name.
For example, if you replaced the tab names with a "State" name eg "NSW" or "QLD" or "VIC", thereby adding a new column in the summary tab called "State", that would show the corresponding state to each record. Hope this makes sence :)
Good video. Short and precise.
Sir, my third column consists alphanumeric anfr numeric data, but the master sheet is capturing numeric values only how to resolve this issue kindly advise
Hi Michael is there anyway to do the opposite where Input data in one master sheet and the data automatically fills in corresponding sub sheet !! Thanx in advance!!!
This is excellent. How about if i update any data under column B - D on each worksheet. can it also reflect on the master worksheet?
Could you use something like bold or hidden and bull for the query?
How do I Add conditional formatting to column A if column b, c, d...are true or yes?
Thanks bruh! This has been extremely useful for my business.
This was exactly what I needed. Thank you so much
Hi Thanks for this.. Got a question though ... what's is this for? "Select * where Col2 ''",1)
Thank you brother, for sharing this tutorial, keep up good job!
Hi, this is awesome thanks for this! Just wanna ask if there's a way to just put all the months into "dropdown" so I can just select a month and will show me all the data from it without showing all the months and data together. Hope this makes sense. Thanks in advance!😊
What if I have data in two tabs in our case: Website URLS, But need the Email data from the 2nd tab to come over and match the Url in the main tab. How would we do that if the URLS are scrambled on the main tab in its Website URL column?
Where were you Hiding till now????????
Thanks a lot.
This is super useful thanks! I'm using this to show weekly performance for clients into one sheet. The query works well and brings only the 2nd row of each client sheet so that every week, I can see performance for this specific week for all clients. However, whenever I add a new row for the new week on the client sheets, the formula automatically moves to the 3rd row instead of staying in the 2nd row. Any idea how I could ensure it only takes the 2nd row? I've used the dollar sign but it doesn't work. I also saw INDIRECT and OFFSET formulas online but couldn't make it work (I think it's because I'm using a range rather than a specific cell).
Can we have tutorial for syncing Excel to Google Sheets automatically? I know of Sheetgo which is not free unfortunately.
I want to add that "Where Row is not null". How can I use this query for Rows?
I need this! Thank you!
Excellent video. Very clear. Thank you.
what doing the opposite like" Combine cash Book" where you type information onto the home page and it automatically appear on the ,months sheets instead, please let me know.
Thank you so much , but I have one question , When I add data at sheet 1, I dont want this data I added appear between 2 sheet combined, I want this data I added appearing the next row in big sheet
How to do , can I help me
This is nice, but what I really need is the opposite. I need to auto fill data from master sheet to individual sheet. I have 10 customers and as I fill in the monthly sales data, I want the data to auto fill to each individual customer sheet. Is there a formula for this. Thanks
If the data from any of the columns in the original sheets change, will it automatically change it in the master sheet as well?
Thanks for the help. I tried this but an error comes up #VALUE!. What am I getting wrong?
When you highlight over the #VALUE error, what does it say?
Hi, i have been running into an error. The formula works till column 1 but if i add col2 or 3 i get an error. Please help!
Hi, i am unable to copy data from one sheet and paste into another like you did, if i use { then a error pops up, which doesnt let me continue. Please suggest
Thanks so much for this, it's really well explained! :)
I wanted to ask, how about when I have data validation set up in my multiple sheets and I want to have them all appear in one master sheet? I keep getting errors when I use this formula, and I think it's because I have data validations set up.
I think you're asking how to have one source for your dropdown menu options and then use this source for all of the sub-sheets?
You want to create the sheet (Dropdown Menus) with the dropdown menu options on the master sheet.
Then you import the Dropdown Menus tab into each of your sub-sheets. And you'll use this imported tab as the data validation source.
@@hustlesheets Hey, do you have an example of this in any of your newer videos?
I am unable to use the formula added in this video. Would you mind sharing it? While using it, it gives me errors.
Unable to use this formula for some reason. after entering the open bracket it message states theres a problem with the formula
How do you continue this with all new sheets (months) without need to edit the formula?
Thanks a million - it's what I needed!
I have one large master sheet and want to copy data to a different work sheet with multiple tabs how? Ex. Master sheet has a column with multiple store names. The other sheet is a sheet with stores as tabs. I want to copy data form master using store names to the appropriate tab on the other worksheet. Think it is the importrange but not sure how to filter it for each tab.
Is there a way to make formatting show up, like font or text/cell color?
thanks,. I do have a question. What if you wanted to have just one master sheet but all the other sheets would draw down from the master sheet. For example, if you have 100 units of X, and 15 different sheets, if 1 was entered in all the sheets it would draw down from the 100 units where the master sheet is. So it would reflect 85 units of X
Any way to add the same cell from multiple sheets?
I'm not a coder but I have the first part done and it works as described, with large gap between tab groups on the master sheet. When I enter the query commands I get an error! I notice you don't mention spaces between commands, ie- select (space) * (space) where (space) col1, etc. But I've tried it with and without spaces and get error. Feels like I'm so close! I'm using this to do materials lists that I can send out on one master sheet for pricing. The lists are broken down into construction phases (doing a porch with roof- so one tab is all for deck construction, another for roof, another for trim work, etc. Thanks for offering this and any suggestions are appreciated!
Is there a reason why you started the all months list in column B instead of A like all others?
@@openhand7502 Hey! The only reason I did that is to make it easier to see where I was trying to highlight in the month tabs. You can start the formula anywhere you like.
@@openhand7502 You definitely need spaces between the commands. What error are you getting?
I got it to work! I capitalized "Col" and it's all working. This is a huge help for what I'm doing. I see I'm one of only a few subscribers to a new channel? I want to send my encouragement- this was a top notch tutorial
@@hustlesheets
@@openhand7502 awesome! I'll make sure to add an annotation to the video capitalize "Col1". Thank you!! I'm going to have a lot more videos on the query formula coming out!
Thanks for your video, short and simple. Excellent...
GREAT tutorial. Thank you so much.
What if I want to add April May and June later? Do I have to do this each time I add a tab?
Very helpful, Michael! How can I add info from only certain columns together. I.E. I am tracking student attendance and need to see how many days they're missing for the year. I have a sheet for each month that tracks different info, but I want to have a cumulative form that tells me only how many days total they are missing for the year. Can you give me any advice?
Instead of saying "SELECT *" you would only select the desired columns ie. "SELECT A,C,E,F"
let me know if you have any other questions
Hey dude, do you know how to also copy over the color on color coded cells? I have the master sheet working but we color code certain things as they happen. This does not transfer over to the master sheet although the data itself does. TIA
oh yea thats not going work..
a workaround can be having a column for this... so lets say green = good and red = bad
have a column called Status, and then have the same formula that codes it red or green as in your conditional formatting, except make it say "Good" or "Bad"
then when this column is imported, make a conditional formatting based on this column
lmk if this makes sense or if you want me to do a video on it
Good .👌 Will it work for huge number of data...I want to combine more than three sheets in a single master sheets...
Why on the last sheet you did not use the first column?
Hey, this has been working succesfully for merging data sheets but not for dates. For example when I do =(2018!B2:B440) which are hospital names it perfectly pastes but when I did the same function for a column that has dates like 2018/01/01 it pastes random numbers
Bro i have one excel with 48 tabs and data is diff in each tab pls help how can i combine to show all data on google studio for dashboard preparto