Macro: This section will teach you how to record simple macros and what exactly a macro is.

Brief introduction of Macro
Macro is a very powerful productivity tool. A macro is a sequence of instructions or set of tasks combined so you can run or replay the entire sequence or set with a single command. You may create a macro, for example, to print or format your sales report. Once a macro is developed, with one click you can execute the macro to perform the time-consuming procedure automatically.

VBA is the language we use to create a macro. In Excel, the Record Macro feature on the Developer toolbar is a great feature. Without knowing VBA language you can create simple and useful macros. For complex programming you have to have an understanding of VBA language. In summary, this is one of the most powerful tools of MS Excel.

What can we do with Macro’s?
The answer to this question is very simple: we can use Macro for anything and everything that is repetitive. For example, if you are preparing the same kinds of reports on a daily basis, you can create a macro that will prepare the reports with one click of your mouse.

How to record a simple Macro?

Step 1 – Open Excel workbook, select worksheet 1 and go to Developer tab.

Step 2 - Click on Record Macro. The window below will open.

Macro name – You can replace the name of the Macro to be recorded to fit your needs. Macro1, Macro2, etc. is the default name.
Shortcut Key – You can assign the macro to a shortcut key; for example, if you type A in the box, you can execute or run the macro by pressing Ctrl+A.
Store macro in – This is the name of the workbook where you want to keep the macro, e.g. This workbook, New workbook, etc.
Description – You can define the macro so it shows what will happen when the user runs the macro.

Click OK to record the macro.

Step 3 - write at Range A1 = Workbook, B1 = Worksheets, C1 = Range, then select worksheet select and select Range A1:D1.

Now click on Stop Recording

Step 4 – You have created a macro by the name of Macro1. To run this macro, click on Macros or press the shortcut key if you have assigned one.

Step 5 – Select the Macro you have created and click on Run. This macro will do the same task you did manually in worksheet one and worksheet two. In simple words, this recorder tool has recorded the steps you performed in the Excel workbook, and when you click on the Run button it will do the same thing.

Below is the code of the recorded macro. This is just example of basic steps for how to record a macro. Using the same process, you can record anything you do in Excel and get the valuable code.

Now you understand the basics of Excel Macro’s. For the next step, see the page on VBA, the programming language for Excel Macro’s.
Request Quote by Email

*Required fields


  • I needed an Excel macro that had a lot of moving parts. Rob helped me spec out exactly what I needed, then delivered the exact functionality, on time. He's a professional.
    Travis Van, ITDatabase
  • I have used with great satisfaction for many years and continue to use their services. Their ability to efficiently and effectively devise elegant solutions to complex problems is unsurpassed in this space. I could not recommend EAC more highly.
    Justin Barr , Managing Principal, Loan Workout Advisers, LLC.
  • The Access project ExcelAccessConsultant did for me was on time and exceeded the specifications.
  • (Access project) Rob does excellent work and is a pleasure to work with. He knows his stuff and is very thoughtful about putting solutions together to solve problems. Most importantly, he's extremely collaborative; I feel as though he is a true partner when we work on something together. I hope we get to work together again.
    Bart Schwartz, Industrial Channel Research
  • ExcelAccessConsultant was awesome. I contacted them with my problem. They created a simply spread sheet with formulas that cut my work in half. This project was done in 1 day.
    Kim Shower, Maximum Day Services
  • Excel Access Consultant always delivers a great product on time and within budget. They make sure the customer is happy with the end product. They make sure on the front end that the deliverables are clear so that no time is needed on the back end to correct formatting, calcs, etc.
    Glen Casanova, Principal Consultant, Cobia Capital
  • Rob took the time to listen to my needs and work with me to understand my Access project. His work exceeded my expectations.
    Dino Accettone, Accettone Funeral Home Ltd
  • I found EAC via Google search. In the search field I entered "Excel Guru" - enough said!
    Genie Wood, Marketing Director, TBS Factoring Service
  • EAC has a thorough and professional-level understanding of Access reports. We will definitely call upon them with any of our Access needs.
  • EAC did a very good job and in a very timely manner. I would use ExcelAccessConsultant again and recommend them.
  • Rob did an excellent job customizing an Excel spreadsheet that meet our company's need to manage information. He was very responsive and delivered the product in a timely manner. We are very pleased with the entire process and the results. I will not hesitate to use Rob for the company's future needs.
    Alex Leung, Artichoke Joe's Casino
  • I found Rob when searching the internet. During the project, I was always able to contact Rob directly (as advertised!) and the quality of his work and meeting time schedules exceeded my expectations. Rob is a true professional and I'm very pleased that I choose him for my excel project! Rob was a pleasure to work with and was very fair with billings--thanks again, Rob!
    Darwin Brown, B4CRM
  • Excellent service and response time. I had a tight deadline and EAC was able to work with me to achieve the deadline.
  • The excel project worked better than I expected it could and made my client very happy.
  • Rob showed me he was extremely adept at writing some very difficult codes for a spreadsheet project I worked on.
    Jay Jennings, North Texas Surfaces
  • I contacted EAC with a relatively small project, but needed it fast. They delivered quickly and even helped with a small revision quickly.
  • Rob listened to my needs and figured out a solution. His work was timely and he was always responsive. Excellent to work with.
    John Kelly, Managing Director, Janney Capital Markets
  • EAC is customer focused and provides an excellent level of service. They are responsive and also highly capable. I highly recommend the services.
  • Rob was very responsive and made adjustments to the project due to some of the miscommunications on my end that made the project more complicated than needed. In the end, Rob sorted it out and we have a functional simple program that is saving us a significant amount of time. Thanks Rob!
  • We had a project which would have taken me days to create, I sent it to Rob over a holiday weekend and it was done when I came in the next morning.
  • Responded quickly and accurately. Just what I needed.
  • On time . Nailed it first time. Extremely satisifed.
    JR Fogarty, Managing Member, Paradise Enterprises, LLC
  • We needed help fast! We are a medical laboratory that tests 25% of this nation’s blood supply and are under strict FDA regulations for obvious safety reasons. Mr. Terry provided us with a swift, accurate system that not only performed as expected but continues to function. We automated tube the check-in process and Mr. Terry’s system checks every tube # for accuracy and duplication (average of 22,000 tubes per week). The system was supposed to be temporary but is still going strong 7 months later. I do not hesitate to recommend Mr. Terry. Not only did he respond quickly, he stayed around to make sure his work was appropriate for our needs.
    Harry Felker, Database Administrator, Laboratory Information Management Creative Testing Solutions
  • Rob was great to work with. Understood my needs and delivered a solution to fit my needs.
  • Rob took the time to listen and fully understand what I was trying to accomplish, both tactically and strategically. He then came up with suggestions and executed the project in a timely and efficient manner. His support after the project was outstanding too!
    Frank Weber, Ask Forensics
  • The answers to my questions were explained in a way that I could understand and the results were outstanding.
    Wilfred Dennis