Some of the key benefits of spreadsheet automation
is, accuracy of the end product, reduction in man hours and speed
of work turn around.
As an example, a property company held a list of over 2000 tenants
and building costs on a spreadsheet and once a quarter these tenants
would be billed with these costs. During this quarterly billing
cycle the company would employ 3 temporary staff over the course
of a week to manually type the information from the spreadsheet
to invoices. Utilising Excels VBA code this process was reduced
to one existing member of staff pressing a button to create all
the invoices in just a few hours, the speed of this process was
limited by the printer speed! The company now saves money on temporary
staff costs, the time taken to train these staff and benefits
from no human input errors.
|
|
