Category: Excel
-
Application Deployment
When distributing Excel or Access applications I usually create an install program to setup the application correctly for the user. I use Inno setup which does a great job of packaging the files creating the user shortcut and ensuring they have installed the program into the correct location. When deploying these apps within a corporate…
-
Pension Calculator
As an accountant I get asked a lot about how long a persons pension pot will last or when I think they can retire. The honest answer is it depends ! What your current outgoings are , do you have debt , what age you are etc etc. I prepared this simple Excel model to…
-
Consolidate the contents of multiple excel sheets
This is a very useful macro to add the contents of several excel sheets onto a single sheet