Dynamic Report Building – Leveraging Excel VBA
One optimization we’ve been striving for with all our clients nowadays is dynamic reporting – the goal is to create reports that are future-proof to GL hierarchy changes. Consider the P&L report below: Note that the Expense accounts (colored orange) are divided into subcategories Compensation, External Labor, and Strategic. These subcategories are then further drilled […]