Category: Automation

This post is about a common business problem of grabbing messy data from a transactional document and updating a dataset to collect history.  In my previous life, I was in Commodity Export Marketing, so I am using the ‘real world’ …

Grabbing messy data with VBA Arrays Read More »

Tagged with: , , , , ,

OK so this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system.  See here for Part A.  This example concerns automating entries on your bank statement you can reliably identify.  …

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries Read More »

Tagged with: , ,

I have been putting off blogging about this topic because it’s unwieldy to explain and  involves work done many years ago that I would do better now.   I cringe a bit seeing an Offset formula now which I would only …

Save time using Excel Templates to upload to your accounting software – Part A The Cash Book Read More »

Tagged with: , , , , ,

Sometimes people who have a ‘real job’ and don’t work at a computer all day and know how to use a nail gun and an angle grinder ask, what do you do for a living mate? If I say financial …

What Do You Do for a Living mate? Read More »

Tagged with: ,