I have a Pivot table on Sheet "Purchases" and would like macro to select the "Blank" from filter drop down in A2 if Cell C10 on sheet "Recon" is zero, otherwise select highest year from Filter
I have attached sample data
It would be appreciated if someone could assist me
I have also posted on https://www.mrexcel.com/forum/excel-...sed-value.html
See my code below which I cannot get to work as per my criteria
If C10 on sheet 'Recon" is zero then filter must be "Blank", otherwise select Highest Year in filter , based on max year on "Raw Data"
Bookmarks