how about when you move it, it will also remove it from the "All Months" tab. its like instead of copy paste it will be cut and paste. is that possible?
Hey! thank you so much for this epic tutorial. You're awesome. Getting a little stumped though. How would this same formula work if you wanted to separate by Names rather than months? Any advice would be greatly appreciated :)
This was really insightful and helpful, but I'm trying to figure out what I did wrong. It's only pulling in the header from my refernence sheet into the new sheet.
This is excellant! Is there a way to do this and keep the data live - so that if I make a change on the master sheet, the change happens in the Jan tab as well?
Hi, Thank you for the video. I am looking for a way to put all my primary info on a master sheet and pull them according to the need in other sheets and insert additional secondary information with them in those other sheets. I have a master sheet say sheet1 with 10 columns- Column A:J. I copied the 1st 7 columns A:G in sheet2 using query function. I don't need the last 3 columns H:J info of Sheet1 into Sheet2. Instead I manually inserted different info in sheet2 columns H:K. Lets say I have 2 rows in sheet1 (so naturally sheet2 also has 2 rows), then I added a new row in between the 2 rows So previous A2:G2 info moved to A3:G3 in both sheets. But my manually inserted H2:K2 info did not move to H3:K3. Is there a way I can achieve this? Thank you.
Can you provide any insight on how I would change the formula around if I want to focus on one Column, more specifically, type of courses offered/interested to high school students. On this column I have a drop down menu with multiple options they can select. Up to two selections. Thanks in advanced!
Is there a way to pull a row from another sheet but stop at a certain cell? Trying to pull A row from sheet2 onto sheet1 but stop taking data after column F
OMG thank you for this! Is there any way to also copy over hyperlinks rather than strictly just the text from one tab to another? That's the only thing holding me up.
If you have a hyper link that goes to a "website" on one tab how can I get that hyper link to follow in to the the "master sheet". I have my guys entering Ref numbers from salesforce and I am adding the hyperlink for them, the problem is when I add the hyper link for sales person A - B or C the hyperlink does not follow onto the master sheet so that I can just look at the master sheet and not all the other tabs to get the hyperlink.
Hey I want to Do the exact same thing you did in this video but I want to filter the rows from Master Sheet to a new sheet using Checkboxes. So every time a checkbox Is ticked I want that row to be copied to the new sheet from the Master. and if it is unchecked then get removed from the new sheet. Can you tell me how that can be done please?
I've tried all of these functions and they do not work for me... The training is very fast and not very detailed.. I have tried to stop the video and convert the information to my spreadsheet for about 2 hours and just getting error messages.
Are you able to pull from multiple columns? Say =QUERY(Master!A1:J,"SELECT * WHERE F = 'Spartans' ") I'm doing a sports schedule so I have home and away teams in their respective columns. I'd like to add column H in the WHERE part
This is such a clear explanation. What if I want to pull rows from multiple tabs into another tab in the same spreadsheet that meet the certain criteria? I tried this formula =QUERY({Jac!A2:G;Qin!A2:G;Eze!A2:G},"select * where G='1'") and got a "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: G" error. Please help?
Hello, can you please send me the link to the video of where you populate a master sheet (tab) with values of a row based on certain text in several other tabs. Basically I have 20 or 30 tabs for tasks that I have to do and when they're open, I have a cell that say's "OPEN". I want the master tab to show all of my "open" tasks
What if you're trying to pull rows from one tab to another based on MULTIPLE criteria? For example, I'm tracking sales data. I want to pull all rows where the salesperson's name (column L) is "Zac" and the result of the sales call (column P) is blank, meaning there is no outcome yet. This way, I can see at a glance all the leads Zac is actively working on.
How would you merge URL's with their email in one tab TO another tab (which is the main tab) That has the URL's scrambled, so that the empty email column on the Main tab is populated with the corresponding emails found but matches the right URL?
This is great! I'm wondering if there is a way to use this formula but for data that does not exist on the existing sheet (yet). I'm trying to use this formula to move lines of data over from a tab where a google form populates
Can the new tab be locked? So that once data is pulled from first tab new columns can be added and locked to rows independent of data being pulled regularly from first tab?
I'm creating a database for my company. I see that I can use this method to assign clients to employees by giving each employee a tab in the workbook....but is there a formula to graph information inserted in cells from the same row as the assorted results? Master > Sorted list > Graph
I’m using an API add-on to pull crypto prices to my spreadsheet. The issue is that the data tends to end up in different rows and/or columns whenever it’s refreshed. My question is, how can I tell it to pull the price of ‘Bitcoin’ when the rows and columns aren’t static? Ideally, I’d like to set it so that I don’t have to type each coin name in and can match it to the “A1” on the page I’m pulling it to.
What about if column D was just numbers and I wanted to copy anything greater or equal to 100? I played around with the function, it seems the query thing shown in the video doesn't work with numbers or maybe I'm just doing it wrong (high possibility im just doing it wrong).
Thank you for this video - it worked just as described except for the column where I have inserted an image. Is there a way to get the images to pull over as well??
What if you want to leave the matching phrase unspecific? For instance each Tabs' A column contains unique customer IDs though not in the same order. I want H column on one sheet to match C column on another only when A column matches on both.
This was helpful, thank you! What if instead of selecting an specific date i want the current date, would it be something like "TODAY", could you show the format for this? Also, if if my date is like mm-dd-yyyy, in that order, what would be the script?
I want to copy a row value that is changing wrt time. I want to create series of data with time in another sheet in google spread sheet. How it is possible
hi michael, do u have a video where to measure the handling time of an email? let say u have 5 members handling emails and on the 1st tab ~this is the place where the members will put the information like the there's a counter for date, name, dept, query (log ins, purchase, password reset) this page is only shown to members and very friendly user page. members will have their own tabs. and there will be a tab for all information that they have entered on each of their tabs. on their tabs -we can only provide necessary information and there will no way that they can enter unaccetble data/info that will greatly affect to the master file? Is there also away that the masterfile will be protected even if each member's tab made an error or unacceptable data? what I meant is the masterfile for reporting purposes can be harmed or when we look it there will still be information or data on it, meaning it will not be damaged or deleted or edit or manipulated or something.... sorry for the long message, hope u can help me thank you so much
thats what i needed but i need it to be able to be edited on the new sheet so it wont transfer over to the next and wont error on me when i try to edit
This is really helpful, I just have a follow up question. What if my data set I'm trying to pull has some special characters like the last name O'Brien?
This works great, HOWEVER, one of the rows in the master sheet contains Text with a link underneath (View More) but when I use this formula it just pulls across the "View More" text without the link. Is there any way to ensure that the link pulls through as well?
You can't pull hyperlinks. I would suggest you always have the URL in a dedicated column, and then pull the URL. Then create a helper column if needed and use the HYPERLINK formula if you want to
If I change the background color of a cell on the master sheet, how do I get the background color to pull over to another tab? I was able to follow your instructions and get the text to pull but not the background color.
On my spreadsheet, I have a column that comes from checkbox answers on a Google Form. If I have tabs for each student, is there a formula that I could use that basically says, "If this checkbox answer contains the student's name, them copy it to that student's tab." Any feedback you can give would be amazing. Thanks so much for this great video.
I've been trying to figure this out for days, this was so helpful! Would it be possible to delete the rows in the main tab after they have been moved into the secondary tabs?
Great video! Quick question, what if I have columns in the second tab that are dependent on the data imported from the other tab? Say for example a SUM of two columns that were imported from the first tab. They are not automatically showing, I have to go ahead and apply the formula to those cells especifically. Is there any way for these to show automatically?
Will this formula also pull new data? I will be adding more data to master sheet and would like for data to transfer to a new sheet based on same criteria.
Dang, I've been searching for this function. I'm literally crying tears of joy right now. This is the last piece to my puzzle at work. Thank you!
You saved me from a mental breakdown. Thank you so much!
Dude! thank you. I have been banging my head trying, match, lookup, and arrayformula to make this work. So much simpler with query!
I was looking for a way to do this. I watched a few videos and yours was 100 times the simplest and quickest way to get to the result!! awesome!!
GREAT video! I have a ton of old data at work to sort through and this will help immensely!
YOU sir are incredible. I need to learn from you from now on. True spreadsheet master.
You just saved me hours and hours of work. Thank you so much for this video, I have been scouring for help.
Loved! you made my day buddy. Seriously I have been trying to solve this problem for last 3,4 days and here it was the solution... You're Gem!
This answered exactly every question I had. Thank you.
how about when you move it, it will also remove it from the "All Months" tab.
its like instead of copy paste it will be cut and paste. is that possible?
Hey! thank you so much for this epic tutorial. You're awesome. Getting a little stumped though. How would this same formula work if you wanted to separate by Names rather than months? Any advice would be greatly appreciated :)
This has just helped me out big time THANK YOU!
This was really insightful and helpful, but I'm trying to figure out what I did wrong. It's only pulling in the header from my refernence sheet into the new sheet.
Can you use a term like
This is excellant! Is there a way to do this and keep the data live - so that if I make a change on the master sheet, the change happens in the Jan tab as well?
Hi, Thank you for the video. I am looking for a way to put all my primary info on a master sheet and pull them according to the need in other sheets and insert additional secondary information with them in those other sheets.
I have a master sheet say sheet1 with 10 columns- Column A:J. I copied the 1st 7 columns A:G in sheet2 using query function. I don't need the last 3 columns H:J info of Sheet1 into Sheet2. Instead I manually inserted different info in sheet2 columns H:K. Lets say I have 2 rows in sheet1 (so naturally sheet2 also has 2 rows), then I added a new row in between the 2 rows So previous A2:G2 info moved to A3:G3 in both sheets. But my manually inserted H2:K2 info did not move to H3:K3. Is there a way I can achieve this? Thank you.
THANK YOU!!!! You are the best! You completely saved me today. :)
Can you provide any insight on how I would change the formula around if I want to focus on one Column, more specifically, type of courses offered/interested to high school students. On this column I have a drop down menu with multiple options they can select. Up to two selections. Thanks in advanced!
Is there a way to pull a row from another sheet but stop at a certain cell? Trying to pull A row from sheet2 onto sheet1 but stop taking data after column F
OMG thank you for this! Is there any way to also copy over hyperlinks rather than strictly just the text from one tab to another? That's the only thing holding me up.
If you have a hyper link that goes to a "website" on one tab how can I get that hyper link to follow in to the the "master sheet". I have my guys entering Ref numbers from salesforce and I am adding the hyperlink for them, the problem is when I add the hyper link for sales person A - B or C the hyperlink does not follow onto the master sheet so that I can just look at the master sheet and not all the other tabs to get the hyperlink.
Hey I want to Do the exact same thing you did in this video but I want to filter the rows from Master Sheet to a new sheet using Checkboxes. So every time a checkbox Is ticked I want that row to be copied to the new sheet from the Master. and if it is unchecked then get removed from the new sheet. Can you tell me how that can be done please?
Thanks for the assistance! Perfect tutorial.
I've tried all of these functions and they do not work for me... The training is very fast and not very detailed.. I have tried to stop the video and convert the information to my spreadsheet for about 2 hours and just getting error messages.
Are you able to pull from multiple columns? Say =QUERY(Master!A1:J,"SELECT * WHERE F = 'Spartans' ")
I'm doing a sports schedule so I have home and away teams in their respective columns.
I'd like to add column H in the WHERE part
Great video. This is similar to SQL. I love it!
I know this is an old video, but how could this exact thing apply if you're using "Dropdowns"?
You are awesome, many thanks mate!
Thank you!! This really helped my business
This is such a clear explanation. What if I want to pull rows from multiple tabs into another tab in the same spreadsheet that meet the certain criteria? I tried this formula =QUERY({Jac!A2:G;Qin!A2:G;Eze!A2:G},"select * where G='1'") and got a "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: G" error. Please help?
Hello, can you please send me the link to the video of where you populate a master sheet (tab) with values of a row based on certain text in several other tabs. Basically I have 20 or 30 tabs for tasks that I have to do and when they're open, I have a cell that say's "OPEN". I want the master tab to show all of my "open" tasks
What if you're trying to pull rows from one tab to another based on MULTIPLE criteria? For example, I'm tracking sales data. I want to pull all rows where the salesperson's name (column L) is "Zac" and the result of the sales call (column P) is blank, meaning there is no outcome yet. This way, I can see at a glance all the leads Zac is actively working on.
How would you merge URL's with their email in one tab TO another tab (which is the main tab) That has the URL's scrambled, so that the empty email column on the Main tab is populated with the corresponding emails found but matches the right URL?
This is great! I'm wondering if there is a way to use this formula but for data that does not exist on the existing sheet (yet). I'm trying to use this formula to move lines of data over from a tab where a google form populates
look at around 2:00
I copied your formula and it still doesn't work
It say Query has been completed with an empty output
Thank you so much!
So once this formula is applied will it automatically auto-copy data from the master sheet to the client. Kindly advise. TIA.
Can the new tab be locked? So that once data is pulled from first tab new columns can be added and locked to rows independent of data being pulled regularly from first tab?
I'm creating a database for my company. I see that I can use this method to assign clients to employees by giving each employee a tab in the workbook....but is there a formula to graph information inserted in cells from the same row as the assorted results?
Master > Sorted list > Graph
Can you provide the formula to pull a specific range from column D? Such as great than $200?
I’m using an API add-on to pull crypto prices to my spreadsheet. The issue is that the data tends to end up in different rows and/or columns whenever it’s refreshed. My question is, how can I tell it to pull the price of ‘Bitcoin’ when the rows and columns aren’t static? Ideally, I’d like to set it so that I don’t have to type each coin name in and can match it to the “A1” on the page I’m pulling it to.
What if there are variations of the data being pulled for example "Jan" or "jan" how do we adjust to the formula to account for that?
What about if column D was just numbers and I wanted to copy anything greater or equal to 100? I played around with the function, it seems the query thing shown in the video doesn't work with numbers or maybe I'm just doing it wrong (high possibility im just doing it wrong).
Thank you for this video - it worked just as described except for the column where I have inserted an image. Is there a way to get the images to pull over as well??
What if you want to leave the matching phrase unspecific? For instance each Tabs' A column contains unique customer IDs though not in the same order. I want H column on one sheet to match C column on another only when A column matches on both.
This was helpful, thank you! What if instead of selecting an specific date i want the current date, would it be something like "TODAY", could you show the format for this? Also, if if my date is like mm-dd-yyyy, in that order, what would be the script?
I'm also curious about the "TODAY' function
I want to copy a row value that is changing wrt time. I want to create series of data with time in another sheet in google spread sheet. How it is possible
hi michael, do u have a video where to measure the handling time of an email? let say u have 5 members handling emails and on the 1st tab ~this is the place where the members will put the information like the there's a counter for date, name, dept, query (log ins, purchase, password reset) this page is only shown to members and very friendly user page. members will have their own tabs. and there will be a tab for all information that they have entered on each of their tabs. on their tabs -we can only provide necessary information and there will no way that they can enter unaccetble data/info that will greatly affect to the master file? Is there also away that the masterfile will be protected even if each member's tab made an error or unacceptable data? what I meant is the masterfile for reporting purposes can be harmed or when we look it there will still be information or data on it, meaning it will not be damaged or deleted or edit or manipulated or something.... sorry for the long message, hope u can help me thank you so much
Is it possible to copy cells from one sheet to another sheet based on a drop down list into specific cells
Thanks, it helped a lot
i want to move a row from google sheet after 24 hours and move it another sheet automatically
thats what i needed but i need it to be able to be edited on the new sheet so it wont transfer over to the next and wont error on me when i try to edit
This is really helpful, I just have a follow up question. What if my data set I'm trying to pull has some special characters like the last name O'Brien?
That shouldn't be affected by this formula. Are you having issues pulling in that text?
This works great, HOWEVER, one of the rows in the master sheet contains Text with a link underneath (View More) but when I use this formula it just pulls across the "View More" text without the link. Is there any way to ensure that the link pulls through as well?
You can't pull hyperlinks. I would suggest you always have the URL in a dedicated column, and then pull the URL. Then create a helper column if needed and use the HYPERLINK formula if you want to
If I change the background color of a cell on the master sheet, how do I get the background color to pull over to another tab? I was able to follow your instructions and get the text to pull but not the background color.
you actually can't pull colors using a formula. You'll just have to set the colors in the new sheets beforehand :)
@@hustlesheets OK thanks! I can stop trying to figure how to make that happen LOL
@@dianemccallister1388 I recommend conditional formatting within your new sheet for this to automatically change the colors of cells.
Brother why the Date has serial number 1 , cant be empty ?
thank you so much
On my spreadsheet, I have a column that comes from checkbox answers on a Google Form. If I have tabs for each student, is there a formula that I could use that basically says, "If this checkbox answer contains the student's name, them copy it to that student's tab." Any feedback you can give would be amazing. Thanks so much for this great video.
I'm running into a similar issue. I've copied the formula in this and altered it for the contained data and it only ports over the very first row
I've been trying to figure this out for days, this was so helpful! Would it be possible to delete the rows in the main tab after they have been moved into the secondary tabs?
Great video! Quick question, what if I have columns in the second tab that are dependent on the data imported from the other tab? Say for example a SUM of two columns that were imported from the first tab. They are not automatically showing, I have to go ahead and apply the formula to those cells especifically. Is there any way for these to show automatically?
Thanks!
Skills! Thanks!!!!
Will this formula also pull new data? I will be adding more data to master sheet and would like for data to transfer to a new sheet based on same criteria.
Hi, what do you mean by new data? If you are adding rows the other tabs, they will automatically pull into the master tab
Yes - you can use this with Google Forms to automatically pull results into specific tabs in your sheet, including new form entries.
Does this avoid duplicate data?
How to Pull Rows From One Tab To Another Tab in Another Spreadsheet?
How to Automatically Move Row to Specific sheet Based on Text In google sheet
can i just pay you to fix my stuff.
amazing
Too fast and I am lost. Not a good example
Thanks!