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.--
trigger
------------------------------------------------------------------------
trigger's Profile: www.excelforum.com/member.php...foamp;userid=6354
View this thread: www.excelforum.com/showthread...hreadid=500688