Automate your excel sheets with VBA

Automate anything and everything

Photo by Samuel Sianipar on Unsplash

VBA (Visual Basic for Applications) is widely used for automating MS-Office products. Most of the time, when you are working with loads of data and want to automate your tasks, VBA comes in very handy.

Last week, I had to work on dozens of workbooks and had to do some process of data cleaning over them. If I would have…