| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recreating a pivot table using code
I have a table of items and their quantities.
In column A I have the item names, which are often repeated and in column K I have their quantities. The table spans rows 90 through 120 Is there a way to consolidate the quantities in the list programatically without using a pivot table? The consolidated table needs to appear below the main table with the items in column A and the totals for each item in column K Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Code - Simple Code Fix? | Excel Programming | |||
| Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
| Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names) | Excel Programming | |||
| VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
| Trouble recreating Pivot table changes in VBA | Excel Programming | |||
Linear Mode
