ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Recreating a pivot table using code (https://www.excelbanter.com/excel-programming/437827-recreating-pivot-table-using-code.html)

Roger on Excel

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?




All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com