VBA introduction to VBA and create a macro in Excel
In Excel, a macro or VBA (Visual Basic for Apps) is a code written in Visual basic to automate tasks
The tasks range from simple data manipulation to complex functions such as charts,pivots and so on.
The macro can be created as follows.
Select View Tab
Click Macros , give a name and click Create button
The Visual Basic Editor opens where you can write the required code.