Hello, I have a data set from which I have 2 pivot tables.
I want to link the two so that when I filter using one of the headers (dropped in the page section of pivot) both tables filter to the one command.
Is this possible pelase?
Hello, I have a data set from which I have 2 pivot tables.
I want to link the two so that when I filter using one of the headers (dropped in the page section of pivot) both tables filter to the one command.
Is this possible pelase?
do mean like this ?
Not quite. I mean tlike in the re-attached.
On Sheet 2 - I want for Data 1 (in the first table) to select 6 (for example) and then automatically the second table selects only 6 for Data 1.
You can perhaps utilise something along the lines of:
To insert the above right click on the sheet holding the PT's select View Code and insert above into resulting window (ensure Macros enabled thereafter).Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Excellent and useful as ever DonkeyOte.
I was close to similar code - but it didn't work.
Yours did
I am having the same issue. But cant see the link...
Where do I enter in 2010?
Please Login or Register to view this content.
Last edited by arlu1201; 09-17-2012 at 04:15 AM.
Huff2009,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
Also,
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi CMB80,
I have tried using DonkeyOte's vba, and with no luck, were you able to use his? and if so can you please take a look to see where I went wrong?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks