Oct 15, 2019
Can you pull data from MULTIPLE tabs and have it auto-populate a single tab? How do you do this?
I am currently using this formula:
- =query('TEA (main cabinet)'!A4:AB,"Select * Where B='DATA'")
- =query('TEA CART'!A4:AB,"Select * Where B='DATA'")
- =query('Adagio Sample Sets'!A4:AB,"Select * Where B='DATA'")
However, I need all three of these to merge into one query OR find another formula that will allow me to pull from three tabs to merge into one tab.
DATA refers to the tea types - each tea type needs to merge into it's own tab. So:
- Black teas from "Tea (main cabinet)", "Tea Cart", and "Adagio Sample Sets" tabs will all show up into the "Black" tea tab.
- Shou teas from "Tea (main cabinet)" and "Tea Cart" tabs will all show up into the "Ripe/Shou Pu'er" tea tab.
- etc etc etc
Finally, I have some tabs that have teas I would like to put in a misc category. So "purple" tea, "hei cha", and "buds" would all obtain their own category. Therefore, DATA (in the query) would need to be multiple values. For example:
- =query('TEA CART'!A4:AB,"Select * Where B='DATA 1, DATA 2, DATA 3'")
*Green Tea tab needs to have a combination of all of this. Not only does green tea need to pull from "Tea (main cabinet)", "Tea Cart", and "Adagio Sample Sets" but it also needs to be able to pull both data sets in column B "green" and "matcha" from the "Tea Cart" tab.
I feel SUPER out of depth here. It's all pieces I know how to do individually but I feel like there has to be a way to combine it all!
Thanks in advance for your help!
Details
Community content may not be verified or up-to-date. Learn more.
Last edited Oct 15, 2019
All Replies (4)