Gilberto also wants to display the total accessory sales from the previous year. This data is stored in another workbook.
In cell B12 of Gilberto's workbook, insert a formula using an external reference to cell B10 in the Accessories worksheet in the Support_EX19_EOM5-1_Accessories.xlsx workbook. In excel how to
To insert a formula using an external reference to a cell in another workbook, follow these steps:
1. Make sure both workbooks are open in Excel.
2. Go to cell B12 in Gilberto's workbook.
3. Type the following formula: ='[Support_EX19_EOM5-1_Accessories.xlsx]Accessories'!B10
4. Press Enter to apply the formula.
This formula will pull the data from cell B10 in the Accessories worksheet of the Support_EX19_EOM5-1_Accessories.xlsx workbook and display it in cell B12 of Gilberto's workbook.