Daily tips for using Microsoft Excel.

Saturday, January 25, 2003

If you work in a corporate accounting, finance or operations department, you certainly have had to deal with the dreaded rollup process. You know the drill - someone (probably you!) creates an Excel worksheet. These worksheets get sent out to dozens of regions for completion by the regional managers. You then collect the sheets, try to do a rollup, only to discover that Joe in Chicago added 3 rows and two columns, totally screwing up the analysis....

I have found a solution to the rollup issue. Check out my article on the new rollup software from Balenz. This is a great product that every company should not be without.