I want to make a worksheet that will summarize the data from two spreadsheets, called "cars" and "parts", which have three columns each, one for description, one for SKU, and one for quantity.
I'm trying to make a third worksheet display only those rows in the other two worksheets with a quantity of greater than 0. I want to split the third summary worksheet into two horizontally split sections, one for cars, one for parts. I need to subtotal the "parts" and subtotal the "cars" sections, and then make a grand total.
so the third worksheet would show
I want this to be a dynamic worksheet, so if you change the quantity of a line item in "cars" or "parts", it will automatically show up in the third summary worksheet.
Can someone help me out a bit? I'm lost as to where to go on this....
Bookmarks