Tag: <span>Macros</span>

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 […]
Read Now