Microsoft Office Forums extract specific pivot table data to a new sheet

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2016, 10:08 AM
theexpat theexpat is offline extract specific pivot table data to a new sheet Windows 7 32bit extract specific pivot table data to a new sheet Office 2007
Novice
extract specific pivot table data to a new sheet
 
Join Date: Feb 2016
Posts: 6
theexpat is on a distinguished road
Smile 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.
Attached Images
File Type: png PTable.png (13.7 KB, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract specific pivot table data to a new sheet 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
extract specific pivot table data to a new sheet 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
extract specific pivot table data to a new sheet VBA: Include Dynamic Sheet Name In Pivot Table Source Data ibrahimaa Excel Programming 2 04-28-2012 12:27 AM


All times are GMT -7. The time now is 08:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft