We all have those annoying Excel jobs we’d like to automate. Re-arranging numbers, breaking data out into files or collating information into a single workbook – these are all examples of manual work in Excel that we’d rather not do. Believe me – you’re not alone if you feel like this! At Tiger, we help companies automate this kind of manual work – saving huge amounts of time and money in the process. And, the Excel files we create usually revolve around Excel VBA. So, how can you use Excel VBA to automate manual work in Excel? Welcome back to 30 Day Excel Analyst!

DOWNLOAD THE RESOURCES HERE

Watch The Video HERE

So far in automation week, we’ve learned how to generate VBA code using the macro recorder, and how to trigger that code using a button. We’ve also at least touched on the five key skills areas of Excel VBA: interacting with cells, using variables, controlling position on the spreadsheet, expressing conditionality in Excel VBA and implementing loops. The focus today is on the final key skill area – implementing loops in Excel VBA – and on bringing everything together to create a powerful Excel VBA routine to automate a typical manual process.

As always, I hope you’ll download the Excel download file (VBA included!) and work along with me. And remember, we cram a lot into these 30-minutes sessions. Perhaps you’re finding the pace challenging. If so, check out our best and most popular free Excel VBA learning resources – I’ve collated the links below.

Now you’ve got started, don’t miss this opportunity to develop your skills and confidence in Excel VBA – it could prove career- (or life-) changing!

READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY