Macros are one of the Excel's most powerful features, They can help you automate repetitive tasks.
- Steps/Tasks can be recorded using macro recorder
- Wherever you find using same thing again and again at that time we consider a macro
Steps to enable developer tab
- Macros and VBA tools can be found on the Developer tab, Which is hidden by default
- Click the File tab then Click Option
- On Excel Options Window Click on Customize Ribbon
- Under Customize the Ribbon and under Main Tabs, select the Developer check box
- Developer tab is enabled
Record Macro
- In the Code group on the Developer tab, click Record Macro
- Perform functions to automate, like entering the data in to a table
Use Relative References
- Macros are recorded with actions relative to the initial selected cell
Example for Macros- Adding data to the table
- Macros are recorded with actions relative to the initial selected cell
Example for Macros- Adding data to the table
Adding Macro to the button to automate the process
Enter the details and click on save to save the details in table
