Worksheet that only shows rows with quantity greater than zero
 

I want to make a worksheet that will summarize the data from two
spreadsheets, called “cars” and “parts, and make this 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 total the "parts" and total the
"cars" 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 “cars” or “parts”, it will automatically show up in the
third summary worksheet.

Does this make sense? I'm sorry if I'm putting this in the wrong forum,
but I've tried Pivot Tables and such, and I think this would be a fairly
simple and straighforward need, and something that could be done without
VB.


--
trigger
------------------------------------------------------------------------
trigger's Profile: http://www.excelforum.com/member.php...fo&userid=6354
View this thread: http://www.excelforum.com/showthread...hreadid=500255