Macro recorder - rkarolina/rkarolina GitHub Wiki

About feature

Macro recorder allows you to automate a repetitive task you often do in MS Excel. You can save time and reduce human error. To create a simple macro, you don't need to have any programming skills. MS Excel automatically records your actions (like clicks, typing, formatting, etc.) and converts them into VBA code behind the scenes.

What you can automate?

• you can apply the same formatting to different sheets
• generate reports/PDF with the same layout
• perform calculations and copy results automatically

Steps:

1. Open Excel and go to the View/Developer tab.
2. Click on Record Macro.
3. Enter: Macros name, shortcut key (optional), description (optional).
4. Choose where to store the macro (This Workbook, New Workbook, or Personal Macro Workbook)
5. Click OK to start recording.
6. Perform the actions you want to automate (e.g. formatting, entering formulas).
7. When done, click Stop Recording (in the View/Developer tab).
8. To run the macro, go to View → Macros → View Macros, select it, and click Run.
9. Enjoy!

Tips:

• saving a macro in the Personal Macro Workbook allows you to use the macro in any Excel file on the same computer

• you can add your macro to the Quick Access Toolbar for one-click access:

  File → Options → Quick Access Toolbar

  In the dropdown Choose commands from, select Macros.

  Select your macro and click Add >>.

  (Optional) Click Modify to choose an icon and rename it.

  Click OK.

  Your macro will now appear as a button in the toolbar at the top of Excel.