Macros in Excel | Part 2

Macros in Excel:
Requirement: Microsoft Excel 2019

In Excel, a macro is a sequence of instructions that automate the tasks. Macros are written in VBA (Visual Basic for Applications) and can be used to perform repetitive tasks, manipulate data, or create complex calculations without manual input.
You can always run a macro by clicking the Macros command on the Developer tab on the ribbon.

What are Relative References?
In Excel, the way of recording actions within a macro that is relative to the cell or range that the macro starts from is known as a relative reference. When you start recording a macro with relative reference, Excel records the actions based on the position of the active cell at the beginning of the macro. The recorded actions will adjust accordingly when the macro is run on different ranges.