…In this workbook called linkage formulas, recognize we've got…four sheets for different states Colorado, New Mexico, Arizona, Utah.…And also set up ahead of time is a…total sheet where we'd like to get information here…from each of the separate sheets and possibly even…tabulate the data by gathering data from different sheets.…There are two broad approaches to getting data from one sheet to another.…I'm not talking about copying data, but…writing formulas here and in different approaches.…
If we want this information right here to be coming from…the Colorado sheet, one approach is to begin at the source data.…In other words, let's go to the Colorado sheet, and what we'd like to do here is to…take this total and make sure that we also have that represented on the totals sheet.…We want to do this in such a way that if any of the data in here changes and causes…this total to change, we want the total that we're about to set up to also change.…
So, two broad approaches.…The first approach is not my favorite, but it…
- Explain how to recover a deleted worksheet.
- Identify the purpose of the Protect Workbook command.
- Summarize the steps to view more than one worksheet at the same time.
- Recognize the steps for grouping nonadjacent worksheets.
- Explain the purpose of PivotTables and the Consolidate command.
- Recall the selection that allows users to display the name of all sourced workbooks.