Automating Excel with VBA Programming (Macros)
We probably use and know well the options and methods provided by classic MS Excel for processing, transforming and displaying various data. Indeed, the visual interface of MS Excel and the possibilities provided by it are the basis for the widest use of MS Excel in the most diverse spheres of life and work.
However, it should also be recognized that performing many operations takes a significant amount of time, with repeated/multiple operations in workbooks, these operations become tiring and tedious for the user in pages.
The good news is that MS Excel has a built-in programming language (VBA) and a tool to use it! And with them we can perform even unimaginable actions and transformations, all kinds of automation, even dialogue with the computer, and all this at tremendous speed!