Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag 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.

Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandra Smith


That worked, thank you.