In Excel, to automate a repetitive task, you can use the macro recorder to quickly record the steps in a macro. You can also use the Visual Basic Editor to write ...
support.office.com