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 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 quot;partsquot; and subtotal
the quot;carsquot; sections, and then make a grand total.
so the third worksheet would show

Code:
--------------------

SKU Description Quantity
A5486 Mini 5
A8788 Bug 1
A5544 Lexus 8
Car Total 14
A8888 Muffler 1
A5433 Transmission 4
A6633 Brake Pads 3
Part Total 8
Grand Total 22

--------------------

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.

Can someone help me out a bit? I'm lost as to where to go on this....--
trigger
------------------------------------------------------------------------
trigger's Profile: www.excelforum.com/member.php...foamp;userid=6354
View this thread: www.excelforum.com/showthread...hreadid=502899Here's a sample file which provided some ideas:
www.savefile.com/files/6395325
AutoExtract n Stack Qty Lines From 2 Sheets

Sheets: 1 amp; 2 (Side-by-side output)
Sheets: 1a amp; 2a (Stacked up output)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;triggerquot; gt; wrote in
message ...
gt;
gt; I want to make a worksheet that will summarize the data from two
gt; spreadsheets, called quot;carsquot; and quot;partsquot;, which have three columns each,
gt; one for description, one for SKU, and one for quantity.
gt;
gt; I'm trying to make a third worksheet display only those rows in the
gt; other two worksheets with a quantity of greater than 0. I want to split
gt; the third summary worksheet into two horizontally split sections, one
gt; for cars, one for parts. I need to subtotal the quot;partsquot; and subtotal
gt; the quot;carsquot; sections, and then make a grand total.
gt; so the third worksheet would show
gt;
gt; Code:
gt; --------------------
gt;
gt; SKU Description Quantity
gt; A5486 Mini 5
gt; A8788 Bug 1
gt; A5544 Lexus 8
gt; Car Total 14
gt; A8888 Muffler 1
gt; A5433 Transmission 4
gt; A6633 Brake Pads 3
gt; Part Total 8
gt; Grand Total 22
gt;
gt; --------------------
gt;
gt; I want this to be a dynamic worksheet, so if you change the quantity of
gt; a line item in quot;carsquot; or quot;partsquot;, it will automatically show up in the
gt; third summary worksheet.
gt;
gt; Can someone help me out a bit? I'm lost as to where to go on this....
gt;
gt;
gt; --
gt; trigger
gt; ------------------------------------------------------------------------
gt; trigger's Profile:
www.excelforum.com/member.php...foamp;userid=6354
gt; View this thread: www.excelforum.com/showthread...hreadid=502899
gt;