For this reason, perform your steps in exact order without extraneous actions. The macro recorder is now recording your every move, but don't be nervous. Click OK when you are ready.įigure 1.10 Before recording your macro, complete the Record Macro dialog box. In the Description field, add a little descriptive text to tell what the macro is doing (see Figure 1.10). You might want an easy way to run this macro later, so enter the letter i in the Shortcut Key field. Make sure that the macros will be stored in This Workbook. Change this to something descriptive like ImportInvoice. In the Record Macro dialog, the default macro name is Macro1. Click the Record Macro button on the Developer tab. Open a blank workbook and save it with a name such as MacroToImportInvoices.xlsm. From the Home tab, select Format, AutoFit Column Width.Īfter you have rehearsed these steps in your head, you are ready to record your first macro.Highlight the Total row and click the Bold icon on the Home tab to set the totals in bold.Highlight Row 1 and click the Bold icon on the Home tab to set the headings in bold.Click the AutoFill handle and drag it from Column E to Column G to copy the total formula to Columns F and G.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |