To create the external reference formula, open up the source workbook, then click the cell in the dependent workbook where you will put the formula.Įnter an equal sign into the cell to start the formula. The syntax for this formula is = (WorkbookName) SheetName!CellAddress. To link one workbook to another, you will use an external reference formula. Whenever you link workbooks, you make it so that one workbook is dependent on the other. The dependent workbook is the workbook that contains the formula that links it to the other workbook. It is dependent on the information in the other workbook. The source workbook contains the information used in the dependent workbook. If the information linked to in the source workbook is updated or changed, those updates or changes will be reflected in the dependent workbook as well.
COMPARE AND MERGE WORKBOOKS EXCEL 2016 NOT SHOW HOW TO
The worksheets do not have to be in the same workbook. In this article, we are going to learn how to link and consolidate worksheets. Linking two worksheets together means using references to cells in an external worksheet to bring data into your worksheet. Consolidating means to combine or summarize data from two or more worksheets.