Show description

IMPORTANT: The (Paste Name) shortcut is not available in the Input range and Cell link text boxes of the Format Control dialog box. xls Worksheets CHAPTER 1 Worksheet 12 – Worksheet List Worksheet 12 — Worksheet List contains the list of worksheets in the workbook. You can update the worksheet list by using the Update_WorksheetsList macro, below, and entering it into a regular module. xls Workbook and Presenting Information. com/f96-s. xls Worksheet 13 – Parameters and Calculations This worksheet stores the Combo Box cell link (cell B2) (as described in Category 1: General, Parameters and Calculated Worksheets, page 4) and formulas that calculate the Reports Date, Reports Month Number, and Reports Year Number (as shown in rows 3 through 5 in Figure 1-1).

3. In the corresponding cell in column B, type the name of the new account. Step 2: Defining Names After carrying out the previous step, define the names of the columns and one row, as follows: Φ Column A: Adj_AccountNumber Φ Column B: Adj_AccountName Φ Column C: Adj_Number Φ Column D: Adj_Debit Φ Column E: Adj_Credit Refer to Step 2: Defining Names, page 26, for the naming procedure. ¾ To define a dynamic range name for the Adjustment list: 1. Select a cell in the Adjustments list, and press .

A$1,0,0,COUNTA(Adj_AccountNumber),5) For an explanation of this formula, refer to To define a dynamic range name for the Trial Balance list, page 27. Last printed: 9/3/2005 9:13:00 AM Last saved: 8/11/2005 4:15:00 PM Adjusting the Trial Balance CHAPTER 2 Step 3: Auditing the Trial Balance Adjustment Balances After adding the required adjustments to worksheet 92 — Trial Balance Adjustments, you should make sure that they are balanced, and then update and correct those that are not. This is done by: ✦✸ Adding a list containing formulas that sum the balances of the adjustments, as shown in Figure 2-2.