Forum Discussion
How to add Row Data from one tab to another once a quantity is filled in each tab.
Hello, I am stuck and I'm sure it's an easy formula. I have a workbook with about 16 tabs that have data in each row. and a master tab where I want to collect the data on depending on the quanti...
If you're using Excel 365, perhaps this:
=LET(Stack,VSTACK(AllSheets),FILTER(Stack,(TAKE(Stack,,1)<>0)*(ISNUMBER(TAKE(Stack,,1)))))The FILTER criteria is a bit longer because the arrangement of the data across sheets is not the same. The header row starts in different places so a criteria had to be added so it doesn't pull text.
- this is exactly what I was after! thank you.
- You're welcome!
- Well, I broke it again. I'm getting an #CALC! error. I have been working to simplify my workbook and must have moved stuff around and broken the formula. any help you can give would be amazing!
