Читать книгу Excel Macros For Dummies онлайн
18 страница из 60
Recording a macro is like programming a phone number into your smartphone. You first manually dial and save a number. Then when you want, you can redial those numbers with the touch of a button. With macro recording, you can record your actions in Excel while you perform them. While you record, Excel gets busy in the background, translating your keystrokes and mouse clicks to code (also known as Visual Basic for Applications or VBA). After a macro is recorded, you can play back those actions anytime you want.
In this chapter, you explore macros and find out how you can use macros to automate your recurring processes to simplify your life.
Choosing to Use a Macro
The first step in using macros is admitting you have a problem. Actually, you may have several problems:
Problem 1— repetitive tasks: As each new month rolls around, you have to make the donuts (that is, crank out those reports). You have to import that data. You have to update those PivotTables. You have to delete those columns, and so on. With a macro you could have those more redundant parts of your monthly process processes done automatically.