I need to capture the overall Dept percentages of Current, Expiring Soon, Expired, and Not Req'd training on a Monthly Basis in order to track whether we are improving on a month-to-month basis. Because November isn't finished yet, all percentages are considered applicable to October until month end.
These may change all month long whenever I update the spreadsheet until the month changes, then they need to become a snapshot as at the last day of the month. So column H 11-15 needs to be copied to Monthly Department Percentages at each month end.
Can this be done automatically?