| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating information
I have eleven different sub assemblies customers can choose from. The
customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I dont have a bunch of 0s taking up a lot of space? This is what Im looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolidating information
Apply Autofilter to your quantity column and from the filter pull-down
select Custom | Not Equal to | 0 PIECES. The offending rows will now be hidden. Hope this helps. Pete "Cerberus" wrote in message ... I have eleven different sub assemblies customers can choose from. The customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I don't have a bunch of 0's taking up a lot of space? This is what I'm looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolidating information
Thank you Pete for your help on this.
"Pete_UK" wrote: Apply Autofilter to your quantity column and from the filter pull-down select Custom | Not Equal to | 0 PIECES. The offending rows will now be hidden. Hope this helps. Pete "Cerberus" wrote in message ... I have eleven different sub assemblies customers can choose from. The customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I don't have a bunch of 0's taking up a lot of space? This is what I'm looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolidating information
You're welcome - thanks for feeding back (so few do!).
Pete "Cerberus" wrote in message ... Thank you Pete for your help on this. "Pete_UK" wrote: Apply Autofilter to your quantity column and from the filter pull-down select Custom | Not Equal to | 0 PIECES. The offending rows will now be hidden. Hope this helps. Pete "Cerberus" wrote in message ... I have eleven different sub assemblies customers can choose from. The customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I don't have a bunch of 0's taking up a lot of space? This is what I'm looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolidating information
Is there a way to have it refresh if the customer changes the option?
"Pete_UK" wrote: Apply Autofilter to your quantity column and from the filter pull-down select Custom | Not Equal to | 0 PIECES. The offending rows will now be hidden. Hope this helps. Pete "Cerberus" wrote in message ... I have eleven different sub assemblies customers can choose from. The customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I don't have a bunch of 0's taking up a lot of space? This is what I'm looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolidating information
I don't know of any way to make it automatically refresh, other than with a
macro. Pete "Cerberus" wrote in message ... Is there a way to have it refresh if the customer changes the option? "Pete_UK" wrote: Apply Autofilter to your quantity column and from the filter pull-down select Custom | Not Equal to | 0 PIECES. The offending rows will now be hidden. Hope this helps. Pete "Cerberus" wrote in message ... I have eleven different sub assemblies customers can choose from. The customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I don't have a bunch of 0's taking up a lot of space? This is what I'm looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolidating information
Okay, thanks again Pete.
"Pete_UK" wrote: I don't know of any way to make it automatically refresh, other than with a macro. Pete "Cerberus" wrote in message ... Is there a way to have it refresh if the customer changes the option? "Pete_UK" wrote: Apply Autofilter to your quantity column and from the filter pull-down select Custom | Not Equal to | 0 PIECES. The offending rows will now be hidden. Hope this helps. Pete "Cerberus" wrote in message ... I have eleven different sub assemblies customers can choose from. The customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I don't have a bunch of 0's taking up a lot of space? This is what I'm looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidating a formula | Excel Worksheet Functions | |||
| Consolidating text information | Excel Discussion (Misc queries) | |||
| Consolidating Rows | Excel Discussion (Misc queries) | |||
| Consolidating information from one sheet to a list on another | Excel Discussion (Misc queries) | |||
| Consolidating??? | Excel Discussion (Misc queries) | |||
Linear Mode
