Consolidating information

  • Thread starter Thread starter Cerberus
  • Start date Start date
C

Cerberus

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
 
Thank you Pete for your help on this.

Pete_UK said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With First attempt at Database Relationships 1
Code help, delete rows based on column criteria 2
Update Correct Records in Table; Based on Certain ID 9
Running a macro from a hyperlink? 2
A question of normalization 6
Multiply qty of filtered records 7
Win API Calls in VBA Need Clarification 1
Problem with text box 9

Back
Top