Classic Example of When to Automate Excel

November 4th, 2004 | Categories: Misc | Tags:
-->

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.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
  1. November 5th, 2004 at 20:21
    Reply | Quote | #1

    I find that my clients are most interested in the time my procedures can save. Pretty charts are a side effect.

    - Jon

  2. November 7th, 2004 at 14:40
    Reply | Quote | #2

    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.