tommy1234
03-20-2011, 12:01 AM
Hello
i have a problem in excel 2007,
i have several pivot table (created from the same table) in the same sheet.
i'm looking for a way to create another sheet that will contain just filters and when i'll choose value all the pivot tables in the pivot sheet will be filtered (according to the value / multiple values i chose) automatically.
can someone help me with vba code ?
thanks
i have a problem in excel 2007,
i have several pivot table (created from the same table) in the same sheet.
i'm looking for a way to create another sheet that will contain just filters and when i'll choose value all the pivot tables in the pivot sheet will be filtered (according to the value / multiple values i chose) automatically.
can someone help me with vba code ?
thanks