You just need to create a link between the worksheets (within the same workbook or in different workbooks) by using what is called an external cell reference or a link.Įxternal reference in Excel is a reference to a cell or a range of cells outside the current worksheet. When calculating data in Excel, you may often find yourself in a situation when you need to pull data from another worksheet or even from a different Excel file. This short tutorial explains the basics of an external reference in Excel, and shows how to reference another sheet and workbook in your formulas.
