| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A VB Code instead of a pivot & sobtotals
Hello,
I have a data table consisiting of different products with sales amounts & volumes. Any product can be included many times. What I want to do, is to add up the amounts or volumes of the same product. Using a pivot table, subtotals in the VB code, slows down the process. Is there any other way to produce a more efficient visual basic code? The table and the result I want to achive: Product Amount Volume A 5 100 Eur A 10 200 Eur B 10 300 Eur B 20 600 Eur The RESULT should be: Product Amount Volume A 15 300 Eur B 30 900 Eur Many Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alter pivot with code | Excel Discussion (Misc queries) | |||
| VBA Code with Pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Table Code | Excel Discussion (Misc queries) | |||
| Pivot Table VBA code to move a row | Excel Discussion (Misc queries) | |||
| HELP! Code for Pivot Table | Excel Programming | |||
Threaded Mode
