It happens many times that we have to accomplish boring repetitive tasks in MS Excel, such as formatting cells in lots of tables, to make them look more professional, in order to print, let’s say, a report for a client. Those tasks, although easy to do, require a lot of time to complete. Repetitive tasks can become a children’s play and all it takes is a little bit of set up in the very beginning.

Then, all you have to do is press one key and look how the computer is doing the job for you. This can be accomplished by using macros.

How much time one can save with macros?

I can tell you from experience that I managed to to do a three-day job in less than 20 minutes, with only one smart macro. It is true, it took me about one week to make it work properly, as it required a little bit of programming as well (because I needed some dynamic actions, I had to edit the macro and to input those instructions by hand). It was worth doing that, as that job was a monthly report which I had to do for a client for two years.

Here are few macros that I personally used in my work.

I will keep sharing more macros with you over time. If you have been using VBA in your work, Please submit the code in the form below for other users.