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 quantity of each row. I have a column that I fill in the qty of each item I want to order and if the data is greater than 0 I want that entire row to auto-populate to the Master tab all of the material tabs will populate that master tab. I hope this makes sense. Please help!
thanks,
6 Replies
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!
here is the link to the sheet.
https://haggardeletric-my.sharepoint.com/:x:/g/personal/dougj_haggardelectric_com/EcoHUlkICFRPgnlG9_DXvv8B4mloewo-fQpeJ3quviQbLA?e=kRqTQb
