+ Reply to Thread
Results 1 to 3 of 3

Two worksheet selection changes for same pivot, different filters

  1. #1
    Registered User
    Join Date
    09-25-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    61

    Two worksheet selection changes for same pivot, different filters

    Hi,

    I am trying to create two worksheet selection changes on the same sheet that will change the filters of a pivot table on another sheet. My first one is working perfectly when I change cell B2, but the second does nothing when i make a change to cell B1. The filters they are trying to change are SIOP Model (this one is working) and SIOP Platform( no change when i change the value of this cell). Below is my code.

    I appreciate any help!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-25-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Two worksheet selection changes for same pivot, different filters

    I understand you cannot run multiple worksheet changes on one sheet. Could someone please help me combine these? Is it possible to combine them if the goal is to change different filters for the same pivot table like I am trying to do?

  3. #3
    Valued Forum Contributor
    Join Date
    08-26-2006
    Location
    -
    MS-Off Ver
    2010
    Posts
    388

    Re: Two worksheet selection changes for same pivot, different filters

    I would use the Worksheet.Change Event instead of Worksheet.SelectionChange.

    Please Login or Register  to view this content.
    Last edited by T-J; 10-24-2013 at 12:25 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Filters through VBA
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2013, 11:29 AM
  2. Pivot Filters within Formula
    By christipper in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-23-2013, 06:34 AM
  3. Multiple filters, dependent on previous selection
    By Amy.H in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2012, 09:10 AM
  4. Replies: 1
    Last Post: 02-22-2012, 12:21 PM
  5. changing range selection for pivot table based on worksheet
    By twhitezell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2010, 11:49 AM

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