<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello all,
I'm no expert in excel but I know my way around vba and formulas. However I need your help.
I have a main sheet with a list of 100 items that users may select and choose the quantity for any given item using drop lists.
The data of the main sheet is then transferred to a second sheet where it extracts duplicates and add up all the quantities for any given item. However, this sheet lists all 100 items with their respective quantities in the adjacent cell, many of which have 0 as quantity.
Now what I need is a way to extract all items that have at least 1 quantity and to “populate” a final list which would show only the items that have quantities and their respective quantities.
I could then print or send this final sheet for ordering the requested items that users need.
Can somebody help me how to go about this. Here is an sample of what I mean
<tbody>
</tbody>
<tbody>
</tbody>
I'm no expert in excel but I know my way around vba and formulas. However I need your help.
I have a main sheet with a list of 100 items that users may select and choose the quantity for any given item using drop lists.
The data of the main sheet is then transferred to a second sheet where it extracts duplicates and add up all the quantities for any given item. However, this sheet lists all 100 items with their respective quantities in the adjacent cell, many of which have 0 as quantity.
Now what I need is a way to extract all items that have at least 1 quantity and to “populate” a final list which would show only the items that have quantities and their respective quantities.
I could then print or send this final sheet for ordering the requested items that users need.
Can somebody help me how to go about this. Here is an sample of what I mean
Items | qty | result I need | qty | |
item1 | 0 | item2 | 2 | |
item2 | 2 | item3 | 1 | |
item3 | 1 | item6 | 6 | |
item4 | 0 | item7 | 2 | |
item5 | 0 | |||
item6 | 6 | |||
item7 | 2 |
<tbody>
</tbody>
<tbody>
</tbody>