Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are Macros and why do we need them in MS Excel?

What are Macros and why do we need Macros in Excel. What if i don't want to use macros what is the alternate method for that?

user-image
Question added by Yasir Ilyas , Front End Developer , CureMD
Date Posted: 2016/11/02
Hossein Ghassemi
by Hossein Ghassemi , Managing Director , Saman Tavan Energy Co

Macros are set of actions that we can use to automate tasks. 

We need them to repeat actions in different times.

Sulaiman Ibrahim
by Sulaiman Ibrahim , Chairman of the Department (Planning And International Cooperation) , Directorate Of Social Affairs

Excel macros save you time and headaches by automating common, repetitive tasks. And you don't have to be a programmer or know Visual Basic Applications (VBA) to write one

Aziza Ali
by Aziza Ali , Quality Assurance Associate , Instashop

It's a software for automation to simple and repetitive tasks, useful for saving hours of time.

nithin s pillai
by nithin s pillai , Facilities Coordinator , Farnek Services

Mini program(no need to write all program codes) used to reduce the man effort

Sanoop Thelapparambil
by Sanoop Thelapparambil , senior associate-payable , UST Global

Macros will allow you record your action in an excel sheet, so that you can apply it when you repeat same set of action in same excel sheeet or differant by running same recorded macro

Etibar  Etibarli
by Etibar Etibarli , Executive Assistant to CEO , Synergyworx International Holdings

Macros is a set of programming which speeds up the work of the user in Excel. It has a code that can be used to avoid repeating the steps of commonly performed tasks over and over again. It can involve complex calculations that require the use of formula as well as simple formatting tasks(e.g adding numbers, updating datas, applying cells, worksheet sample and etc.) 

Automatic way of professional work which is helpful to improve and upgrading the works easily

Kashif Hussain Bukhari
by Kashif Hussain Bukhari , Senior Officer , Adamjee Insurance Company Limited (AICL)

There are several ways to run a macro in Microsoft Excel. A macro is an action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language. You can always run a macro by clicking the Macros command on the Developer tab on the ribbon.

Muhammad Rifaath
by Muhammad Rifaath , Manager Financial Planning & Reporting , Saudi Ground Service Company

Macros are used to automate tasks for a set of actions that are repetitive

We need them to save time in performing repeated actions.

Kasun Chathuranga
by Kasun Chathuranga , Accountant , DSI Middle East W.L.L

Custermized tools which facilitate quick solutions for practical issues.

Muhammad Imran Baig
by Muhammad Imran Baig , Manager Supply Chain , BS Industries

Macros are coding to some repetetive tasks. so we use to make codes to call them within sheet or working.

More Questions Like This