Microsoft Office Tutorials and References
In Depth Information
Entering Raw Data from Other Worksheets
Once you create formulas that return data from one worksheet in
your database, you can copy and modify them to return data from
other worksheets.
In Figure 8-5, for example, here are the key formulas that return
data from the Month worksheet in BudGL.xls workbook:
P13: =MATCH(CurMonth,BudGL.xls!Date,0)
B14: =MATCH(A14,BudGL.xls!Name,0)
D14: =INDEX(BudGL.xls!DataMonth,$B14,D$13)
Similarly, if you needed year-to-date budget data to be in row 14,
you would use this formula for the cell shown:
D14: =INDEX(BudGL.xls!DataYTD,$B14,D$13)
In all cases, of course, you would copy the formulas to adjacent
cells as needed.
Chart Data
This section of Figure 8-5 contains the data used by the chart,
which will be discussed in the next step.
Notice in Figure 8-5 that I’ve left extra rows between the Raw Data
and the Chart Data sections. This is because it’s a good idea to
start each section in the same row of every data sheet for every
chart, and because several other charts will need that extra space
to calculate their results.
By enforcing a consistent structure, you make it easy to change all
chart sheets in one operation.
Row 23 contains dates as they will be displayed in the chart. This
row contains two types of formulas:
Search JabSto ::




Custom Search