LinkBack URL
About LinkBacks
Hi All,
I have about 10 pivot tables and charts. Each table is refined by "week number". Is it possible to combine all the report filters so that the tables will be updated from the one drop down menu?
Thanks,
Adam
Hi All,
I have about 10 pivot tables and charts. Each table is refined by "week number". Is it possible to combine all the report filters so that the tables will be updated from the one drop down menu?
Thanks,
Adam
Hi,
Check out this link -
http://www.needforexcel.com/#!Update...f28ffc7eecbe3f
You will need something like this
Just change the Caption "Date" to whatever is on your pivot table..
Please Login or Register to view this content.
Also change this part to wherever your Drop Down is
Please Login or Register to view this content.
Last edited by NeedForExcel; 08-31-2015 at 06:00 AM.
Cheers!
Deep Dave
You can wrap the above code in a Worksheet Change event, so that as soon as you select values from the Drop Down, all Pivots update on their own..
Something like -
See the file attached.Please Login or Register to view this content.
Last edited by NeedForExcel; 08-31-2015 at 06:51 AM.
Sorry guys,
Is this a macro? I have never used one before. I also have all pivot tables on the one sheet.
First of all, press F12 and save your workbook with .xlsm extension.
Then on the Developer Tab, click on Visual Basic.. If Developer Tab is not enabled, here is how to do it
http://www.needforexcel.com/#!Enable...7-85EDEE74C7C5
Click On Insert > Module & Paste Code From Post #2 there
Then Right Click on the sheet where the Drop Down List is there, and select View Code, Paste Code From Post #3 there.
You will have to change minor things like .PivotFields("Date") & SheetName to what ever you are using..
Refer this if required
http://www.needforexcel.com/#!Update...f28ffc7eecbe3f
Hi,
Sorry to bother you but i cant get it working. I keep getting the following error.
Last edited by Adamlee; 08-31-2015 at 06:51 AM.
Hi,
See the file attached.
Do not forget to enable Macros
31.8.15.xlsx
Readded link
Did the file attached in Post #7 not work for you?
Apologies, i hadnt updated the page.
I have enabled the macro i think, but the following error is coming up
.PivotFields("Week Number").CurrentPage = Sheets("Sheet1").Range("A2").Text
I think you have not tried the file attached in Post #7
I have done everything there and it is working fine..
AHHH Apologies,
I had the weeks as 1531 instead of 31.
Its working perfectly now.
Thank you soo much
No Problem..
Cheers!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks