Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional auto-filtering to summarize data
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 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 "parts" and subtotal the "cars" 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 "cars" or "parts", 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: http://www.excelforum.com/member.php...fo&userid=6354 View this thread: http://www.excelforum.com/showthread...hreadid=502899 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional auto-filtering to summarize data
Here's a sample file which provided some ideas:
http://www.savefile.com/files/6395325 AutoExtract n Stack Qty Lines From 2 Sheets Sheets: 1 & 2 (Side-by-side output) Sheets: 1a & 2a (Stacked up output) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "trigger" wrote in message ... 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 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 "parts" and subtotal the "cars" 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 "cars" or "parts", 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: http://www.excelforum.com/member.php...fo&userid=6354 View this thread: http://www.excelforum.com/showthread...hreadid=502899 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter not showing all data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Need help creating a formula to summarize data! | Excel Worksheet Functions | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
Filtering Data with a Drop Down field | Excel Worksheet Functions |