Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USe VB to Get Pivot Data
Hi,
I need to use VB to extract to different subtotals from a pivot table. Has totals by bundle and totals for each size within a bundle. Examle: Bundle 1010-120 QTY 15 size IK QTY 5 size HK QTY 10 Bundle 1012-120 QTY 6 size IK QTY 6 Bundle 1212-120 QTY 8 size HK QTY 6 I need to extract the bundle types and for each size within the totals for that size I am creating a spearate workbook which will have one sheet per bundle type and to totals - one for each size. I had this done this with extracting the bundle types creating the new sheet and then setting a fomrula with getpivottable data from the originating workbook to set the qty for each size, However, I would like to do this without the formula in the new workbook and just use VB to determine the size and qty and set the value of the new cell to the quantity. Is this possible?? -- WayneR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
Reverse Pivot-type Data (that's not a pivot table) | Excel Discussion (Misc queries) | |||
Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions |