Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
Three tables on one worksheet, need to hide rows | Excel Discussion (Misc queries) | |||
How do I reduce number of Rows displayed in Excel worksheet? | Setting up and Configuration of Excel | |||
How to increase the maximum rows in the worksheet? | Excel Discussion (Misc queries) | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) |