 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Consolidating 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 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 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 >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 [quoted text clipped - 24 lines] > Hendrickson AA250T 2 PIECES > Hendrickson PARALIFT 1 PIECES Thank you Pete for your help on this. > 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 [quoted text clipped - 32 lines] > > Hendrickson AA250T 2 PIECES > > Hendrickson PARALIFT 1 PIECES You're welcome - thanks for feeding back (so few do!). Pete > Thank you Pete for your help on this. > [quoted text clipped - 36 lines] >> > Hendrickson AA250T 2 PIECES >> > Hendrickson PARALIFT 1 PIECES Is there a way to have it refresh if the customer changes the option? > 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 [quoted text clipped - 32 lines] > > Hendrickson AA250T 2 PIECES > > Hendrickson PARALIFT 1 PIECES I don't know of any way to make it automatically refresh, other than with a macro. Pete > Is there a way to have it refresh if the customer changes the option? > [quoted text clipped - 36 lines] >> > Hendrickson AA250T 2 PIECES >> > Hendrickson PARALIFT 1 PIECES Okay, thanks again Pete. > I don't know of any way to make it automatically refresh, other than with a > macro. [quoted text clipped - 41 lines] > >> > Hendrickson AA250T 2 PIECES > >> > Hendrickson PARALIFT 1 PIECES |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.