Sorry, I LOVE anything dealing with pivot tables . . . especially if you add power pivot to them. Thanks to Belinda Allen for this video .
See the article here: GL Summary Trial Balance made easy with Excel Pivot Tables