An AccountingWEB member approached David Carter for advice about ">how to derive monthly management reports from a chart of accounts with 15,000 separate accounts - an unwelcome side effect of multi-segment nominal ledger desgin. David's first impulse is to see if Excel pivot tables are up to the task.
We've had plenty of suggestions on how to handle this monster of a Trial Balance. Most reckon the answer lies in Access or Crystal Report writer.
However, as always, my own initial instincts are to see what an Excel pivot table can do.
So I agree with reader Aongus Curran's suggestion about using Text to Columns to chop up the codes, then Vlookup to bring in some code descriptions, and finally using pivot tables.
P&L pivot table tutorial
Up to now all the pivot table tutorials on Ac...