#1
|
|||
|
|||
extract specific pivot table data to a new sheet
Please help on this daily boring task , if it can be done by Macro or Formula.
From ProductName_general field I select Auto From Productname field i select multiple items (Auto,Auto Balloon,Auto Stepup), From the Channel fieldDIB,DIBLDY,INB selected. then from Zone field i select Zone A after that what is required is to copy the resulting two rows Total Count , Total amount to new Sheet. then Zone B copy the resulting two rows Total Count , Total amount to the same new Sheet. below the two previous rows. . . . the last Zone G. copy the resulting two rows Total Count , Total amount to the same new Sheet. below the previous rows. please please assist. thanks in advance. Reda. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data not showing in Pivot Table | MichelPierre | Excel | 2 | 01-26-2016 10:51 AM |
Extract data based on pattern with respect to specific column | PRA007 | Excel Programming | 14 | 12-04-2015 04:32 AM |
How to Extract Data from table based on pattern. | PRA007 | Word Tables | 4 | 03-17-2015 11:05 PM |
Pivot Table Duplicate Data | cnw | Excel | 0 | 08-31-2012 08:24 AM |
VBA: Include Dynamic Sheet Name In Pivot Table Source Data | ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |