Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

If you’re looking for a straightforward method to automate the generation of Excel reports, such as those for end-of-month financial results, there is a simple solution that can save you time and ...