How to record a macro in excel

You can save above 95% of your working time with excel, if your doing highly repetitive tasks in excel. This can be done easily with the help of record macro function in the Microsoft Excel, even if you don’t have any coding skill . And this article on ‘How to record a macro in excel’ will help you to learn how to do that.

Ok lets start.

If your data processing using excel have following characteristics, record macro function will be highly beneficial to you and you can start using this record a macro function of Microsoft excel.

• have well defined steps
• highly repetitive (that means the same data processing is done in every day or hour, with different data with same data format)
• same data format

Don’t worry if you don’t understand the above characteristics, it can be understood by following example.

I will be explaining this with an example

Example

Here I have three columns in excel

First column is ‘product code’, second column is ‘No of products to be produced’ and third column is ‘month’ as shown in the image below.

Now I need to process this above data to get an output as shown below.

As you can see the ‘No of products to be produced’ is organised Monthly.

You can see the below video for understanding steps I followed processing steps for getting this output from the initial data.

You can notice that I took 1 minute and 53 seconds to complete this task.

How to record a macro

Now I am going to record what I done manually in data processing as macros. Please watch the following video for knowing how to do that. Start and end of the video are very important.

Before recording a macro please save the excel file as macro enabled workbook.

How to save an excel file as Macro enabled work book

Follow following steps,