macro to select year in Filter omn Pivot table

[howard]

I have a pivot Table on sheet "summary"


Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year


It would be appreciated if some could provide me with code to do this

Book1
	A	B
1
2	Financial Year	2020
3
4	Row Labels	Sum of Capital Cost
5	Furniture and Fittings	5500
6	Computers	25600
7	Grand Total	31100
8
9
10
11
12
13
14
15
Sheet1

 

[howard]

Duplicated post in error. After submitting post, I tried to find post but could not so reposted. My apologies, but thought that there may have been a problem on the system