The CCSG Totals worksheet contains totals from stores in two cities. However, you need to link to data in another workbook to obtain the Bloomington values.

Open the Exp$22\_$Excel$\_$Ch$09\_$HOE$\_$Bloomington.xlsx workbook. Go back to the Exp$22\_$Excel$\_$Ch$09\_$HOE$\_$CircleCity.xlsx workbook. In cell C$3$ on the CCSG Totals worksheet, insert a link to the Athletic Apparel department total $($cell B$3).$ Change $B$$3$ to B$3$ in the formula. Use AutoFill to copy the formula from cell C$3$ to the range C$4$:C$10$ using Fill Without Formatting. Close the Bloomington workbook.