View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger on Excel Roger on Excel is offline
external usenet poster
 
Posts: 249
Default 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?