software

I want to make a worksheet that will summarize the data from two
spreadsheets, called quot;carsquot; and quot;partsquot;, 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 with a
quantity of greater than 0. I want to split the third summary worksheet
into two vertically split sections, one for cars, one for parts. I need
to subtotal the quot;partsquot; and subtotal the quot;carsquot; sections, and then make
a grand total.

I want this to be a dynamic worksheet, so if you change the quantity of
a line item in quot;carsquot; or quot;partsquot;, it will automatically show up
in the third summary worksheet.

Please help! This has been driving me nuts for a while now.