Avatar of Sandra Smith
Sandra Smith
Flag for United States of America asked on

Run come when value of a PivotTable flter changes

I have a worksheet that contains a pivotable where the users can select one or more year to view.  However, there is some automatica analsysi that needs to run when the year changes, but am not sure how to tell that when cell D12 (where the year filter is located) changes, run the FTEAnalysis code.  On do not want it t run when anything else changes on the worksheet.

Sandra
Microsoft DevelopmentMicrosoft ApplicationsMicrosoft Excel

Avatar of undefined
Last Comment
Sandra Smith

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rory Archibald

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Sandra Smith

ASKER
That worked, thank you.

Sandra
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck