PC Review


Reply
Thread Tools Rate Thread

Change Pivot Table Row Value on Multiple Tables

 
 
conorfinnegan@gmail.com
Guest
Posts: n/a
 
      21st Aug 2007
Thank you to anyone that can help me out with this request.

I have a workbook that contains three different pivot tables based on
different data, yet one criteria (Type) is the same throughout all of
them. I would like to select multipe values from "Type" on one table
(on the main/first sheet) and have that update the "Type" for each of
the other tables in my workbook. I have an example file that shows
how to do this when based off the same data and if you use page
fields, but I don't have that built this way since it is different
data for each. Also, I can't combine the data into one sheet because
it is too much for Excel to handle. Additionally, I have the pivot
tables built off a database in Access. Can what I am looking to do be
done?

Please let me know. I appreciate it.

Conor Finnegan

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
build a pivot table from multiple other pivot tables. Gordo Microsoft Excel Misc 0 11th Dec 2006 06:56 PM
Consolidating multiple external pivot tables into one pivot table Exiled Microsoft Excel Discussion 1 13th Aug 2006 12:51 PM
how do I consolidate multiple pivot tables into one pivot table? =?Utf-8?B?cGthaG0=?= Microsoft Excel Misc 0 20th Apr 2006 09:48 PM
pivot table with multiple pivot tables as source Jason Microsoft Excel Misc 1 21st Dec 2003 02:13 PM
Pivot Tables - change flat file data from the pivot table Mark Microsoft Excel Worksheet Functions 2 18th Nov 2003 08:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:44 AM.