This is more meaningful than a cell or range address when you look back at them. In Excel, you can assign a name to a cell or range of cells. How to Use Defined Names for Simple Cross References In the following example, a SUM function is summing the values from range B2:B6 on a worksheet named Sales. Start the function as usual and then click on the sheet and the range of cells-the same way you did in the previous examples. But you might want to write a function (such as SUM) that references a range of cells on another worksheet or workbook. Referencing a single cell is useful enough. How to Cross Reference a Cell Range in a Function
Keeping data in one workbook, if possible, is more reliable.
Users creating or renaming folders and moving files can break these references and cause errors.
Although creating references to other workbooks is straightforward, they are more susceptible to issues.
