Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Auto-Population?
I want to make a worksheet that will summarize the data from two spreadsheets, called "cars" and "parts", 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 "parts" and subtotal 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. Please help! This has been driving me nuts for a while now. -- trigger ------------------------------------------------------------------------ trigger's Profile: http://www.excelforum.com/member.php...fo&userid=6354 View this thread: http://www.excelforum.com/showthread...hreadid=500688 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Conditional population of list boxes in Excel? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |