Changing a script to hide columns where the Total = 0 #2873
Description
I have a piece of code which extracts information from an Excel file of Holidays that are approved. The filter is approved holidays from existing Employees.
The script creates a Pivot table of names, against dates and how many days approved per leave (sick leave, unpaid, birthday...etc) but some of the columns are displayed as 0. I would like an If statement to hide these columns.
I have supplied Test data - AugustHolidayGermany
The Output filename has to remain the same - Germany Holiday Report Aug-2025