Select Filter based in Value

[howard]

I would like macro to select the filter in A2 (Financial Year") on sheet summary if Cell c10 on sheet "Data" is zero, otherwise select highest year from Filter


Your assistance is most appreciated

Book1
	A	B
1
2	Financial Year	(blank)
3
4	Row Labels	Sum of Capital Cost
5	(blank)
6	Grand Total
7
8
9
10
11
12
Purchases

 

[howard]

I have also posted on https://www.excelforum.com/excel-pr...-latest-year-on-pivot-filter.html#post5228512

 

[howard]

See link below of workbook


https://www.dropbox.com/s/y2ikypzc04ge8uz/BR1 Assets.xlsm?dl=0


I have tried to write code but cannot get it to select blank if C10 is blank or select year based on highest year if C1 is not Blank