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,
Continue reading with KIE Premium
Unlock this article and all KIE premium articles.
Already have access? Sign in
Secure payment through RazorpayNow or Never
We’ve got your back on your manufacturing journey — Stay in touch
Follow us for step-by-step guidance, templates, and insights that save time and reduce mistakes.
Know Industrial Engineering Platform – Helping manufacturing industry professionals worldwide since 2019
