Recreating a pivot table using code

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

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?
 
Dear Joel,

Many thanks for your prompt help on this one. The code is elegant.

However, I tried your code and found that it enters the first item into the
consolidated list twice?!

Is there a way around this?

Roger
 
Back
Top