Chapter 15. Three-Dimensional Formulas
Questions answered in this chapter:
Is there an easy way to setup a multiple-worksheet workbook in which each worksheet has a similar structure? Can I easily create formulas that involve cells in multiple worksheets?
In many business situations you have to set up workbooks in which each worksheet has a similar format or structure. Here are some examples:
You want to track your company’s sales in each region of the country in a separate worksheet and then summarize total sales in a summary worksheet.
You want to track your company’s sales for each month in a separate worksheet and then summarize year-to-date sales in a summary worksheet.
In this chapter, you will learn how to set up workbooks in which the individual ...