Hi all,

I have a pivot that I need to refresh every few days. Since the data keeps changing, I want the Macro to find the earliest and latest fiscal year in the pivotfield "Fiscal Year" automatically. How can I achieve that with code?

FY.PNG