When you need to quickly automate a task, you can record a macro using the Macro Recorder. Follow these steps:
- Plan the actions you'll take in the macro. You may find it helpful to write them down so that you can perform them in the right sequence when recording the macro.
- Launch Excel if it's not running, or activate it if it is running.
- Set up a workbook with the conditions you need to perform the actions in the macro. For example, if the macro will move some data from one worksheet to another, enter some sample data to move, and make sure that the workbook contains a worksheet you can use as the destination.
Recordfrom the Ribbon or
Record New Macrofrom the menu bar to display ...