Microsoft Office Tutorials and References
In Depth Information
When you report data from this database, you’ll report by a specific
month. This range contains that month number, formatted as
In Figure 7-2, the Date range is defined as: =Month!$E$2:$BB$2.
The DataMonth range contains the actual monthly changes for
each account balance in the General Ledger.
Again, pay particular attention to the gray rows and columns that
surround the actual data. These areas mark the boundaries of the
data area. As you add rows or columns to your data, the range
names will expand as needed if you insert your rows and columns
between these shaded border ranges.
In Figure 7-2, the DataMonth range is defined as:
The DataYTD and DataR12 Ranges
The ActGL.xls workbook contains three worksheets. Until now, all
the range names discussed in this section have been defined in the
worksheet named Month, a simplified version of which is shown in
Figure 7-2. The names DataYTD and DataR12 are the only two
names that will be defined for other worksheets in ActGL.xls.
All three ranges for General Ledger data have the same cell
references, each in its own worksheet. To illustrate, these are the
three definitions for the actual ranges used in the next chapter to
create a sample dashboard: