![]() |
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