+ Reply to Thread
Results 1 to 2 of 2

Filter several PivotTables using a Cell Value

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    12

    Filter several PivotTables using a Cell Value

    Hi Guys, I'm needing some help here.

    The case: I have several pivots on the same sheet, and I want to filter allone according to a Cell value in D1.

    The first pivottable is located on A3

    I tried the following:

    Please Login or Register  to view this content.
    But I'm getting and error saying: "Object Required"

    First, I need to solve how to get the PivotTables names to use in the macro.
    After that, I need to apply this macro to all the tables on the current sheet.

    I'm on Excel 2007.

    Any Ideas?

    Cheers.

    Leandro (from Argentina)
    Last edited by lampoonsaat; 06-27-2011 at 01:04 PM.

  2. #2
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Filter several PivotTables using a Cell Value

    Please take a look at the forum rules and edit your post to use code tags around the code you provided.

    ...
    Thank You, Mike

    Some Helpful Hints:

    1. New members please read & follow the Forum Rules
    2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
    3. If you are pleased with a solution mark your post SOLVED.
    4. Thank those who have help you by clicking the scales at the top right of the post.

    Here...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1