Hi Guys, this is my first post and I am pretty new to Excel VBA also, so I will appreciate your patience.
My issue is that I want to control multiple Pivot Table Filters by using one Combo box in a DIFFERENT Sheet. Why? Because I am building a Data Dashboard for an interesting amount of data that I want to report in a very eye-catching format for my superiors (that will be shown on one Excel Sheet); and use Pivot Table filters to show product performance in different periods of time. This Pivot Tables are going to be in a separate sheet.
I found some interesting solutions in Contextures.com (
http://www.youtube.com/watch?v=3CGLi7t1lDE) for Changing All Pivot Tables When One Changes but when I record the Macro for changing data from Combo Box, something goes wrong.
I also found a way to control the Pivot Table Filter from a Combo Box
http://www.datapigtechnologies.com/f...s/pivot10.html, but it didn't work for me because I use Excel 2007.
I hope you can help me with this issue.
Thanks a lot.
Bookmarks