Question

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

Answer 1

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.