Summary: If you work in the accounts department of a business you might not have access to fancy software… but you regularly use and trust Excel because it’s widely used. What if you’re forced to do lots of repetitive Excel processes by hand? It’s a pain and wastes your time.
I’ve come across tons of manual processes in nearly a hundred projects for a variety of clients. And today I’m going to show you how to automate the process of creating invoices. It’s one of the most common tasks I’ve been asked to automate.
I helped a client to save 37 hours a week with this macro. With my macro they process 750 invoices in 12.5 minutes. And you could achieve similar results. Now, you might worry that it will take a lot of Excel VBA code to do this, but that’s simply not the case.
The macro I use in this article has a few complex parts. So I’ll walk through it step by step. I’m sure you’ll soon get it…and be excited to automate your own document-creation processes!