Next, you want to create a link between two workbooks to ensure the rates in the Music workbook are always up to date by linking to the rates in the Rates workbook. Open Excel_CH07_Rates.xlsx and arrange the workbooks side by side. On the Excel_CH07_Music workbook, group the Valley through Summary worksheets. Click cell C5, and in the formula bar, replace RentalRates in the VLOOKUP function with a link to cell range A4:B14 (named range InstrumentRates) on the Excel_CH07_Rates workbook. Copy the formula in cell C5 to cells C6:C15. Ungroup the worksheets on the Music workbook. Close the Excel_CH07_Rates workbook