Microsoft Office Tutorials and References
In Depth Information
20. On the General page, click DailyCallWorksheet , and then click OK .
Excel creates a new worksheet based on the template.
21. On the Quick Access Toolbar, click the Save button.
The Save As dialog box opens.
22. In the File name box, type CurrentCallSummary . Use the dialog box controls to
browse to the Chapter07 folder, and then click Save .
Excel saves your workbook.
CLEAN UP Close the CurrentCallSummary workbook.
Linking to Data in Other Worksheets and
Copying and pasting data from one workbook to another is a quick and easy way to gather
related data in one place, but there is a substantial limitation: If the data from the original
cell changes, the change is not reflected in the cell to which the data was copied. In other
words, copying and pasting a cell’s contents doesn’t create a relationship between the
original cell and the target cell.