Classic Example of When to Automate Excel
Note to Office Managers: If your employees print something out of Excel to type the printout back into Excel, and do this consistently, you might need to automate.
Even Broader Scope: If your employees print anything out of the computer, to type the printout back into Excel, and do this consistently, you might need to automate.
Automate Excel: To make a process in Excel operate by VBA code, in order to reduce the amount of work done by people, increase the accuracy of the work done, and reduce the time taken to do the work.
I bet you’re very intelligent and can guess the final decision comes down to cost/benefit analysis(cost to automate vs. cost of doing the same), however this example is some of that “low hanging fruit” when looking for areas of improvement, incredibly easy to identify, and also a classic and sometimes hilarious example of when to automate.
Get answers right away at our AE Excel Support Forums!



I find that my clients are most interested in the time my procedures can save. Pretty charts are a side effect.
- Jon
I agree with Jon
However the result needs to look as professional as possible. While they pay for timesaving and code that works, they see the result. They call me back both because I save them time, and I make it look sweeeet.