I tried basic VBA and instantly cut down repetitive work in Excel.

Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to ...