Do you have common tasks that you perform over and over in Microsoft Excel 2000? For instance, do you often apply the same combination of formats, or do you receive data every week or month that you organize and analyze the same way every time? You can use a macro to combine all of the steps in a task into a single command.
Jan 11 2014 12:20 PM
A macro records your mouse clicks and keystrokes while you work and lets you play them back later. You can use a macro to record the sequence of commands you use to perform a certain task. When you run the macro, it plays those exact commands back in the same order, causing Excel to behave just as if you had entered the commands yourself.
Macros are easy to create: you tell Excel to start recording, perform actions as you normally do, and then tell Excel when you're done. Behind the scenes, Excel uses a programming language called Visual Basic® for Applications (VBA) to record your instructions. You don't have to know anything about programming or VBA to create and use macros that will save you time and make your work easier.
This article shows you how to create and use a simple macro that formats a cell, then change this macro to make it do even more. It also explains your options for storing macros so that you can use them from any workbook.
Applying formats is a fairly simple macro example, but you can record macros to do more complex tasks like retrieving and filtering external data, creating and customizing charts, and more.
Simplify frequent chores: record a simple macro
Let's say you work in a group that uses Excel to track accounts receivable. Every week you and your co-workers each submit a report in which your manager expects to see overdue amounts formatted so that they're easy to see: the numbers are bold and red and the cells have red borders. Here's how to record a macro to apply these formats:
In the workbook where you track your accounts receivable, click one of the cells you're going to format.
Point to Macro on the Tools menu, and then click Record New Macro.
In the Record Macro dialog box, type a name for the macro in the Macro name box. Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes