Yes, sometimes I forget ... until I try to build a formula with point-and-click and then I remember!

Recently a client using Sage Accpac asked me to build a statement with side-by-side departmental comparatives in their Excel financial reporter. I jumped in but soon found that it really couldn't be done. I asked Sage Tech Support who checked with Development. They suggested a work-around that is applicable in some situations but not most. Adagio makes that sort of statement a breeze.

Back to the original issue: If I copy-and-paste on a single sheet, the formatting is saved. Why not have the same behaviour when going from one sheet to another?