From 6 Hours to 6 Seconds

By | August 19, 2021

A perfect example of what can be accomplished with Excel was a monthly
“Work center Hours by Division” report I had to complete. I downloaded
data from our ERP system into Excel and then had to create totals by
division & work center. I also had to search out duplicate line items and
delete them, and many of the lines had very similar data so spotting
the duplicates was not easy.

At first it took me about 6 hours to
complete every month. As I improved by Excel skills & learned how to
write macros using VBA this report eventually was completed every
month in 6 seconds, using only 1 click of the mouse!

Do you have a long boring process that you want to be completed in only seconds?  Contact me to see if I can create a custom Excel solution for you!

Leave a Reply

Your email address will not be published.