If you discover manually creating financial plan sheets over and over again in Microsoft Word, task might before tiresome. In its place of continually typing in same credits, debits and formulas, you obtain Excel to format budget sheet for using macro function of Visual Basic for Applications (VBA). The macro function allows to make complex, pre formatted documents and don't want to know only line of VBA code.

Instructions:

• Click "View," then click "Macros then Start Recording."

• Type name for macro into box. For Ex. if creating budget sheet, might want to type "Budget."

•Type easily remembered letter into key mixture box. For ex. you want to choose "B" for "Budget" to get shortcut keys "Ctrl" and "B."

• Press "OK" to start macro recording.

• Click the "Office" button.

• Click on "Blank Workbook."

• Type in order into form usual. For example, if want to generate budget form, you have columns for "Income" and "Expenses."

• Click "Macro then Stop recording" when you have finished workbook. Your macro is prepared to use. click on key combination from Step 3 to generate your new workbook in an instant.