+ Reply to Thread
Results 1 to 2 of 2

Macro for selecting a single item while filtering the data in Pivot Table

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Macro for selecting a single item while filtering the data in Pivot Table

    Hi Guys....m new to this forum and m not sure this is already posted by other members or not.

    i would really appreciate if any one help with this, i need to know whether it is possible have a VBA/Macros script where we can specify to select the group while filtering the data in pivot table and if the group is not found then it should skip and continue selecting other groups.

    Right now when i look at the Macros script, i see that it deselecting all the other groups


    ActiveSheet.PivotTables("PivotTable09").PivotFields("Assigned Group*+"). _
    CurrentPage = "(All)"
    With ActiveSheet.PivotTables("PivotTable09").PivotFields("Assigned Group*+")
    .PivotItems("APAC Desktop Tower").Visible = False
    .PivotItems("Asset Management").Visible = False
    .PivotItems("Carrier support").Visible = False
    .PivotItems("CET-Customer").Visible = False
    .PivotItems("CET-Logistics").Visible = False
    .PivotItems("Customer L2").Visible = False
    .PivotItems("Finance L2").Visible = False
    .PivotItems("Information Access L2").Visible = False
    .PivotItems("L2 ECS*AAS SAP").Visible = False
    .PivotItems("L2 *ECS Oracle DBA").Visible = False
    .PivotItems("L2 *ECS SQL DBA").Visible = False
    .PivotItems("L2 *ECS System Admin").Visible = False
    .PivotItems("LAB Support").Visible = False
    .PivotItems("LCO Support").Visible = False
    .PivotItems("Logistics L2").Visible = False
    .PivotItems("Manufacturing SAP").Visible = False
    .PivotItems("MCOE L2").Visible = False
    .PivotItems("MyOC support").Visible = False
    .PivotItems("NA Procurement").Visible = False
    .PivotItems("People Soft L2").Visible = False
    .PivotItems("PI L2").Visible = False
    .PivotItems("Proconnect Contractor support").Visible = False
    .PivotItems("SMS Support").Visible = False
    .PivotItems("Software Compliance").Visible = False
    .PivotItems("Sourcing L2").Visible = False
    .PivotItems("SRM").Visible = False
    .PivotItems("Warehouse L2").Visible = False
    End With

    , however i want to find a way to select the group i want and if it is not available it should skip and select the rest of the groups, any help would really be appreciated...thanks in advance.

  2. #2
    Registered User
    Join Date
    03-12-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Macro for selecting a single item while filtering the data in Pivot Table

    any one???

+ 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