#1   Report Post  
Posted to microsoft.public.excel.misc
Amk Amk is offline
external usenet poster
 
Posts: 6
Default Excel Pivot Tables

I have 2 pivot tables from the same source data. I want to change the
selection in the page area of one pivot table and have the second table
similarly pivoted. (Both tables have the same field in the page area,)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Excel Pivot Tables

You can do this with programming. There are sample files he

http://www.contextures.com/excelfiles.html

Under PivotTables, look for 'PT0021 - Change All Page Fields'

Amk wrote:
I have 2 pivot tables from the same source data. I want to change the
selection in the page area of one pivot table and have the second table
similarly pivoted. (Both tables have the same field in the page area,)



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 09:05 PM
Excel Pivot tables Steen Excel Discussion (Misc queries) 0 December 7th 07 12:20 PM
new to using pivot tables and excel Wendy Elizabeth New Users to Excel 6 September 21st 07 12:06 AM
Excel and Pivot Tables Michelle Excel Discussion (Misc queries) 5 August 24th 07 03:44 PM
Excel Pivot Tables Brent_in_Oregon Excel Discussion (Misc queries) 0 December 10th 05 12:16 AM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"