Link Workbooks and Set Up Windows You need to consolidate monthly revenue into the fourth quarter…
Link Workbooks and Set Up
Windows You need to consolidate monthly revenue into the fourth quarter workbook using links. To make it easier to create the links, you will tile windows and save a workspace file.
a. Open e08c1theater12, and then save it as e08c1theater12_ LastnameFirstname.
b. Open e08c1theaterq4, and then save it as e08c1theaterq4_ LastnameFirstname.
c. Tile the four windows, making sure the monthly totals worksheets are active.
d. Create links in the e08c1theaterq4_LastnameFirstname workbook to the individual monthly seat revenue and monthly totals. Save the workbooks.
e. Set up a watch window to watch the formulas in the quarterly workbook. Close the watch window.
f. Save a workspace file named e08c1workspace_ LastnameFirstname. Save the individual workbooks, if prompted.