General
[EXCEL HEAVEN] Part 9: Preview - Using SumProduct Formulas to AutoGenerate Spreadsheet Cash Book Summary Reports [How I Built My Automated Cash Book/Bank Reconciliation Software]









This menu driven Payments Summary Auto Reporting interface (see screenshot below) in my Automated Cash Book/Bank Reconciliation App (shown below) taps data it sums into totals from the Cash Book Study the SUMPRODUCT formula in the yellow box shown below... Take note of the syntax and the way range names are used in the formula. Next […]







Read more
Excel-VB Solutions
[EXCEL HEAVEN] JOKES: You Need a Break from Spreadsheets? Enjoy this Compilation of Jokes About MS Excel!









It's true that "All work and no play makes Sule a dull boy and Sikira a boring gal!" So, I decided to publish a compilation of "jokes" about MS Excel I found online (Yep - they do exist!) in this issue of my Excel Heaven Visual Basic Automation Club newsletter, and I've left it "open" […]







Read more